Postgres Pro
Downloads
Home   >   mailing lists

Strange behaviour of trigger functions when initiated via jdbc - Mailing list pgsql-jdbc

From Sebastian Schuette
Subject Strange behaviour of trigger functions when initiated via jdbc
Date
Msg-id 994841525.3b4c13b54ea8c@localhorst.wapcommunications.de
Whole thread Raw
Responses Re: Strange behaviour of trigger functions when initiated via jdbc
List pgsql-jdbc
Tree view 
Hello!

We are evaluating postgres 7.1 and the beta jdbc-driver and found some irritating problem:

There are some trigger functions registered in the database that create records in a log table, when a record in a
datatablegets changed.
If we change records of the datatable via psql or via pgaccess everything works fine. If we
changerecords of the datatable via jdbc, only some of the trigger functions get executed and some not (but the changed
recordsappear in the database). 

Does the jdbc driver has something to do with triggering?

Thanks in advance

Sebastian Schütte
MEDIAonAIR Technologies GmbH
Wittekindstr. 105
44139 Dortmund
Tel: +49 231 10 87 991
Fax: +49 231 10 87 992

pgsql-jdbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: Too much data received?
Next
From: Steve SAUTETNER
Date:
Subject: : SQLException.getErrorCode() : Where can I find list of error code and description ?