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.dr...@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+unsubscr...@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+unsubscr...@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