Re: Multiple semicolon separated statements and autocommit - Mailing list pgsql-hackers

On Thu, 30 Aug 2001 19:56:53 +0200 (CEST), you wrote:
>Rene Pijlman writes:
>> If autocommit is _enabled_ and S1;S2;S3 is send to the database,
>> what exactly is the behaviour of the backend? For example, what
>> happens if S1 succeeds, S2 fails and S3 would succeed?
>
>All three commands are executed in a single transaction.  So if S2 fails,
>S3 would not be executed.

And both S1 and S2 will be rolled back, as I understand it. 

Thank you.

Regards,
René Pijlman <rene@lab.applinet.nl>