Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


Yes that was reported and the issue has been resolved in the coding. Next
releases will include the fix.
See for details.

Best wishes,


On Mon, Oct 8, 2018 at 1:32 PM Albrecht Dreß <>

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

     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 (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; 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,
To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.