How about adding 'set autocommit=on' to the top of each script?
--------------------------------------------------------------------------- Sean Chittenden wrote: -- Start of PGP signed section. > This is pretty chump and easy to get around, but it took me a sec to > figure this out. Anyway, the short and skinny being that with the new > AutoCommit GUC turned off, create(lang|db) won't work until you bail > out of the transaction. A quick hack would be to insert an "ABORT;" > in each of the CLI tools. Anyone have any thoughts on the best way to > solve this? -sc > > -- > Sean Chittenden -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
