Re: [JDBC] Strange behaviour of trigger functions when initiated via jdbc
Sebastian Schuette <[EMAIL PROTECTED]> writes: > There are some trigger functions registered in the database that > create records in a log table, when a record in a datatable gets > changed. If we change records of the datatable via psql or via > pgaccess everything works fine. If we change records of the datatable > via jdbc, only some of the trigger functions get executed and some not > (but the changed records appear in the database). Quite frankly, I do not believe this. Please provide a complete example. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[JDBC] Strange behaviour of trigger functions when initiated via jdbc
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 datatable gets changed. If we change records of the datatable via psql or via pgaccess everything works fine. If we change records of the datatable via jdbc, only some of the trigger functions get executed and some not (but the changed records appear 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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster