implicit rollback?

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: implicit rollback?
Date: 2009-06-17 12:26:30
Message-ID: FCEF5D3E-47C2-4CE5-900F-DE9470598A5E@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mohlomi Moloi 2009-06-17 13:51:14 Re: implicit rollback?
Previous Message Didier Gasser-Morlay 2009-06-17 08:03:19 PostgreSQL 8.3.7 and PHP 5.2.9