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

2018-10-08 Thread Albrecht Dreß 

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

Best, Albrecht.

Am 08.10.18 20:03 schrieb(en) Drew Jensen:

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.

--
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

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

2018-10-08 Thread Drew Jensen 
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ß 
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 “” 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

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

2018-10-08 Thread 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

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 “” 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