Re: [libreoffice-users] libreoffice base/postgres - null columns with trigger/default values

Hi,

You would want to open an issue in the LibreOffice bug tracker and the
module would be Base.
postgreSQL should be in the summary of course.

I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
how long it was working in your production environment. Was it working in
6.0 for instance?

Best wishes,

Drew.





On Mon, Oct 1, 2018 at 6:09 AM Kamil Jońca <kjonca@o2.pl> wrote:

> (This is also described at
> https://lists.debian.org/debian-user/2018/09/msg01107.html)
>
> I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> know where the bug is.
>
> I have simple form based on postgresql table.
> In this table there is a column
>
> name                type                                  nullable default
> value
> utw                 timestamp without time zone           not null now()
>
> This column does not have its field in form.
> With package:
>
> --8<---------------cut here---------------start------------->8---
> Package: libreoffice-base
> Version: 1:6.1.2-1
> Package: libreoffice-sdbc-postgresql
> Version: 1:6.1.2-1
> --8<---------------cut here---------------end--------------->8---
>
> I cannot save filled form to database, because
> "required utw field has no value"
>
> When I drop "not null" from column, and restart libreoffice - form could
> be saved to database.
>
> When I tried with version: 1:6.1.1~rc1-2 of libreoffice packages its
> works as expected.
>
> Should I fill a bug? On debian's page or here? Aginst which
> package/module?
> KJ
>
>
>
> --
> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
> Three may keep a secret, if two of them are dead.
>                 -- Benjamin Franklin
>
> --
> 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