Vick Khera wrote:
I'm running Pg 8.3.7 on FreeBSD 7.2.I have some code in Perl that does a bunch of inserts and updates with all constraints deferred. On occasion, one of the FK's gets violated and the transaction commit fails. I trap this with code like this: unless ($dbh->commit()) { warn "commit failure ".$dbh->errstr; $dbh->rollback(); return 'failed'; } The DBI is telling me that the rollback() is useless with AutoCommit is on (which it is).
Unless I'm mistaken, if AutoCommit is enabled, then each statement will be commit for you. The commit() and the rollback() are both useless.
-Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
