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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
