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

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.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter