Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Added to TODO list: > > > * Add an option to automatically use savepoints for each statement in a > > multi-statement transaction. > > > When enabled, this would allow errors in multi-statement transactions > > to be automatically ignored. > > Note that whoever implements this had better be mindful of the bad > experience we had with autocommit. If there is any way that this > behavior could be turned on underneath an application/script without > the app knowing about it, this would be spectacularly dangerous. > > Like I said, my preference would be that it couldn't be turned on at all > except when psql's input is interactive.
Should we allow it only to be enabled inside a multi-statement transaction, and it turns off when the transaction completes? Doing it only for interactive mode seems too error-prone to me (it works in psql, but not from my script). -- 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/docs/faqs/FAQ.html
