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

Also,

In the issue be sure to show which version of PostgreSQL you are using?

Thanks

On Mon, Oct 1, 2018 at 8:08 AM Drew Jensen <drewjensen.inbox@gmail.com>
wrote:

> 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