From: | "Mohlomi Moloi" <mmoloi(at)khulisa(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, walterc(at)indiana(dot)edu |
Subject: | Re: implicit rollback? |
Date: | 2009-06-17 13:51:14 |
Message-ID: | L97FD6AE543514e33B6357DA9FAA2431C.1245246670.scalix.khulisa.com@MHS |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I think you must explicitly issue a "ROLLBACK" command, reason being I
once created multiple exports to different tables for one form on to
postgres DB and I noticed when I had technical glitch prior ALL exports
being executed some of my records would be missing in my other tables
whilst other tables would populated.
-----Original Message-----
From: Carol Walter [mailto:walterc(at)indiana(dot)edu]
Sent: 17 June 2009 14:27
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] implicit rollback?
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
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2009-06-17 18:33:42 | Re: implicit rollback? |
Previous Message | Carol Walter | 2009-06-17 12:26:30 | implicit rollback? |