Re: [libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

Howdy,

Yes that was reported and the issue has been resolved in the coding. Next
releases will include the fix.
See https://bugs.documentfoundation.org/show_bug.cgi?id=120245 for details.

Best wishes,

Drew

On Mon, Oct 8, 2018 at 1:32 PM Albrecht Dreß <albrecht.dress@arcor.de>
wrote:

> Hi all,
>
> I use LibreOffice as frontend for a PostgreSQL 10.5 database, using the
> native (*not* JDBC) driver.  The minimum way to reproduce the issue is a
> table like
>
> CREATE TABLE tab1 (
>      id bigserial PRIMARY KEY,
>      value text,
>      modtime timestamp without time zone DEFAULT timezone('utc'::text,
> now()) NOT NULL
> );
>
> In LibreOffice I created a form containing these elements, and set the
> property “Input required” on the “Data” tab to “No” for all of them.
>
> Using LibreOffice 6.0.6.2 (Build-ID: 1:6.0.6-0ubuntu0.18.04.1) coming with
> Ubuntu 18.04, this works just fine, in particular it is /not/ necessary to
> enter a value for “id” (marked “<AutoField>” in the form) or for “modtime”.
>
> However, using the official package (Version 6.1.2.1; Build ID:
> 65905a128db06ba48db947242809d14d3f9a93fe) the form is broken.  When I do
> not enter anything in the “modtime” entry, LibreOffice rejects adding a new
> record: a popup is shown, reading
>
> --------------------------------------------------------
> Error writing data to database
> Input required in field 'modtime'. Please enter a value.
> --------------------------------------------------------
>
> which is obviously wrong.
>
> It looks as if LibreOffice 6.1.2 ignores the “Input required” property
> (Actually, in the more complex real project, LibreOffice 6.1.2 requires
> input for columns which are /not/ defined as “NOT NULL” *and* have “Input
> required” set to “No”, but it seems to be harder to reproduce it in a
> minimalistic example).
>
> Did I miss something in the configuration (what?), or is this a bug?
>
> Thanks in advance,
> Albrecht.
> --
> 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