[Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

users
#1

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

#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

#3

Thanks for the pointer, looking forward to the new version!

Best, Albrecht.