> > Of course, the reason they're rollbackable is: > > > > begin; > > create schema newschema; > > set search_path = newschema; > > rollback; > > > > create table junk; -- DOH! > > And: > > set statement_timeout = 20; > query_with_error; > set statement_timeout = 0; > COMMIT; > > That will have to change in autocommit off to: > > BEGIN; > SET statement_timeout = 20; > query_with_error; > SET statement_timeout = 0; > COMMIT; > > I assume that BEGIN does start a transaction. With no BEGIN above, the > big problem is that it will work most of the time, but when/if the query > fails, they will find out they forgot the BEGIN.
Wouldn't it roll back to 0 though because the SET statement_timeout TO 20 was inside of a transaction (assuming the value was 0 before the transaction began)? -sc -- Sean Chittenden ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
