[libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values
kjo...@o2.pl (Kamil Jońca) writes: > Drew Jensen writes: > [...] > > > https://bugs.documentfoundation.org/show_bug.cgi?id=120245 > > Today I upgraded my debian packages and in: Version: 1:6.1.3~rc1-1 there is no mentioned bug. Thank you! KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html Jak ktoś ma pecha, to złamie ząb podczas seksu oralnego (S.Sokół) -- 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] Re: libreoffice base/postgres - null columns with trigger/default values
Drew Jensen writes: > Best way, IMO, since you noticed it first here would be to go ahead and do > that yourself. > This URL assumes you have an account in the bug tracking system. > https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base > If you don't have one and register then submit it you will get > notifications as it is worked. > > Otherwise, if you really would rather not than one of us in the QA group > can do it. > https://bugs.documentfoundation.org/show_bug.cgi?id=120245 KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html I brought my BOWLING BALL -- and some DRUGS!! -- 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] Re: libreoffice base/postgres - null columns with trigger/default values
Hi, I would not be surprised if a change in behavior happened recently, there was some reworking of the sdbc drivers recently which I think had the chance to touch basically all of them. NOTE: I'm not a developer of that code but I try to follow along with the generalities through the QA group. Given two folks seeing the same problem with the latest 6.1.2 build then whether the postgreSQL driver should be updated for that option or needs fixing I can't say, but the step right now is to open an issue and get it started whichever way. Best way, IMO, since you noticed it first here would be to go ahead and do that yourself. This URL assumes you have an account in the bug tracking system. https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base If you don't have one and register then submit it you will get notifications as it is worked. Otherwise, if you really would rather not than one of us in the QA group can do it. Let us know. Thanks Drew On Mon, Oct 1, 2018 at 12:57 PM Kamil Jońca wrote: > Drew Jensen writes: > > > 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? > > I never have registered such probolem, and I use my "application" for > years. > > KJ > > > -- > http://stopstopnop.pl/stop_stopnop.pl_o_nas.html > "I never let my schooling get in the way of my education." > -- Mark Twain > > -- > 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] Re: libreoffice base/postgres - null columns with trigger/default values
Drew Jensen writes: > 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? I never have registered such probolem, and I use my "application" for years. KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html "I never let my schooling get in the way of my education." -- Mark Twain -- 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] Re: libreoffice base/postgres - null columns with trigger/default values
Drew Jensen writes: > Also, > > In the issue be sure to show which version of PostgreSQL you are using? > > Thanks --8<---cut here---start->8--- $psql Pager usage is off. Border style is 0. psql (10.5 (Debian 10.5-1)) Type "help" for help. kjonca=> select version(); version -- PostgreSQL 10.5 (Debian 10.5-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.2.0-3) 8.2.0, 64-bit (1 row) kjonca=> --8<---cut here---end--->8--- KJ -- http://stopstopnop.pl/stop_stopnop.pl_o_nas.html I never take work home with me; I always leave it in some bar along the way. -- 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] Re: libreoffice base/postgres - null columns with trigger/default values
BTW Currently the native MySQL ( MariaDB) sdbc has a setting ' FormsCheckrequiredFields' which can turn that function on or off. Checking just now the PostgreSQL sdbc code does not currently have that option. Yeah, that needs to go into the issue tracker for sure. Drew On Mon, Oct 1, 2018 at 10:50 AM Alexander Thurgood wrote: > Le 01/10/2018 à 12:08, Kamil Jońca a écrit : > > Hi Kamil, > > > > > > 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 > > > > nametype nullable > default value > > utw timestamp without time zone not null now() > > > > This column does not have its field in form. > > With package: > > > > I can reproduce this with : > > MacOS 10.13.6 > postgres 9.5 > LibreOffice 6.1.2.1 > sdbc built-in postgres driver > > If I enter the data in Table data edit mode, then the date is added > automatically. > > However, like you, filling in a simple form including the timestamp > field and leaving the timestamp field blank always throws an error when > I try to move to either a new record, or back to a previous record. What > should happen is that the timestamp value should be generated and the > record validated (as in Table data edit mode). > > > Alex > > > -- > 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] Re: libreoffice base/postgres - null columns with trigger/default values
Le 01/10/2018 à 12:08, Kamil Jońca a écrit : Hi Kamil, > > 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 > > nametype nullable default > value > utw timestamp without time zone not null now() > > This column does not have its field in form. > With package: > I can reproduce this with : MacOS 10.13.6 postgres 9.5 LibreOffice 6.1.2.1 sdbc built-in postgres driver If I enter the data in Table data edit mode, then the date is added automatically. However, like you, filling in a simple form including the timestamp field and leaving the timestamp field blank always throws an error when I try to move to either a new record, or back to a previous record. What should happen is that the timestamp value should be generated and the record validated (as in Table data edit mode). Alex -- 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