implicit rollback? - Mailing list pgsql-novice

From Carol Walter
Subject implicit rollback?
Date
Msg-id FCEF5D3E-47C2-4CE5-900F-DE9470598A5E@indiana.edu
Whole thread Raw
Responses Re: implicit rollback?
Re: implicit rollback?
List pgsql-novice
Hello,

I have a program (PHP) that is executing a number of SQL commands as a
single transaction.  At the beginning of the transaction, I have a
"BEGIN" and at the end I have a "COMMIT".  If one of the transactions
fails, do I have to explicitly issue a "ROLLBACK" command, or will
postgres do this automatically because one of the commands fails?

Carol

pgsql-novice by date:

Previous
From: Didier Gasser-Morlay
Date:
Subject: PostgreSQL 8.3.7 and PHP 5.2.9
Next
From: "Mohlomi Moloi"
Date:
Subject: Re: implicit rollback?