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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl