Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

BTW

Currently the native MySQL ( MariaDB) sdbc has a setting '
FormsCheckrequiredFields' which can turn that function on or off.
Checking just now the PostgreSQL sdbc code does not currently have that
option.
Yeah, that needs to go into the issue tracker for sure.

Drew

On Mon, Oct 1, 2018 at 10:50 AM Alexander Thurgood <alex.thurgood@gmail.com>
wrote:

> Le 01/10/2018 à 12:08, Kamil Jońca a écrit :
>
> Hi Kamil,
>
>
> > I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> > know where the bug is.
> >
> > I have simple form based on postgresql table.
> > In this table there is a column
> >
> > name                type                                  nullable
> default value
> > utw                 timestamp without time zone           not null now()
> >
> > This column does not have its field in form.
> > With package:
>
> I can reproduce this with :
>
> MacOS 10.13.6
> postgres 9.5
> LibreOffice 6.1.2.1
> sdbc built-in postgres driver
>
> If I enter the data in Table data edit mode, then the date is added
> automatically.
>
> However, like you, filling in a simple form including the timestamp
> field and leaving the timestamp field blank always throws an error when
> I try to move to either a new record, or back to a previous record. What
> should happen is that the timestamp value should be generated and the
> record validated (as in Table data edit mode).
>
>
> Alex
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy