On 30 Sep 2009, at 4:01, Vick Khera wrote:
The question still stands: if the COMMIT fails, ROLLBACK is not required in Postgres. Is this portable to other databases?
I don't think so. I recall messages on this list claiming that some databases (MS SQL, MySQL if memory serves me) commit the queries up to the failed query anyway if you issue a COMMIT (which is just wrong!), so the commit succeeds and there's nothing to rollback after that. Some searching should turn up those messages, if I recall correctly the issue at hand was that people expected that behaviour in Postgres too.
But I don't know what Perl DBI does internally when issuing $dbh- >commit(), maybe it's taking such things into account already.
Alban Hertroys -- Screwing up is the best way to attach something to the ceiling. !DSPAM:737,4ac356da11681178911724! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general