How to show postgresql exception errors in 4.1 Base when using a form?

users
#1

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.

I'm using LibreOffice 4.1 and the included PostgreSQL driver, on Linux
(Fedora 18).

Any help would be much appreciated.

Thanks.

Gary.

#2

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

#3

Hi :slight_smile:
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 :slight_smile: