Re: what happens if something goes wrong in transaction?

On Thu, Feb 28, 2008 at 02:19:01PM +0000, A B wrote:
> Hi. newbie question, but what will happen if I do
>
> begin work;
> select ...
> insert ...
> and so on...
> commit
>
> and somewhere a query fails. will I get an automatic rollback?

After the error every subsequent statement will fail with "ERROR:
current transaction is aborted, commands ignored until end of
transaction block."  The transaction doesn't automatically end but
it will roll back even if you try to commit (assuming you didn't
do a partial rollback with SAVEPOINT/ROLLBACK TO).

> I'm using php to make all these calls and they have all to be succesfull or
> no one of them should be carried out.

That's the behavior you'll get if you use a transaction.  No changes
will be visible to other transactions until you successfully commit.

--
Michael Fuhr