Hi :) I thought the postgresql connector got a fairly massive upgrade about a year or so ago? It might be worth contacting the postgresql forums/mailing-list to see if any of their devs are able to do some more work on their connector or to see if we are just missing something about the current one. Regards from Tom :)
________________________________ From: Alexander Thurgood <alex.thurg...@gmail.com> To: users@global.libreoffice.org Sent: Wednesday, 4 September 2013, 10:45 Subject: [libreoffice-users] Re: How to show postgresql exception errors in 4.1 Base when using a form? Le 03/09/13 22:29, Roger Nutbeam a écrit : Hi, > I have a form for entering some data. The data is checked using a trigger > function in postgresql. If an exception is raised by the function, nothing > is shown in the form. It just doesn't complete entering the data, i.e. move > to the next row in the data grid. If no exception is raised the data is > entered into the table via the form, and the cursor moves to the next row. > > Entering the data manually using SQL outside of Base, returns the exception > when it's meant to. The postgresql function is working. > AFAIK, this is not currently supported by the postgres native driver, and I'm not even sure it is by the more general JDBC driver ? How would you tell the driver that the statement execution called by the trigger has failed, when all of this is stored and executed on the server, about which the driver knows nothing ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted