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(at)gmx(dot)net http://funkturm.homeip.net/~peter
In response to
pgsql-hackers by date
|Next:||From: Rene Pijlman||Date: 2001-08-30 19:07:21|
|Subject: Re: Multiple semicolon separated statements and autocommit|
|Previous:||From: Marc G. Fournier||Date: 2001-08-30 17:17:52|
|Subject: test 2 ...|