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(at)lab(dot)applinet(dot)nl>