On Wed, 2004-05-05 at 00:22, Christopher Kings-Lynne wrote: > > I hope not, because for many of us there will be as many (if not more) > > subtransactions than standard transactions. > > How can that possibly be true? Every statement executed in postgres is > a "transaction" how many subtransactions are really needed and how can > they be as common as normal transactions?
Yup.. And some of us intend on wrapping every single statement in a subtransaction so we can rollback on an error without aborting the main transaction. In fact, I would be surprised if tools like psql went very long without doing the same thing so users can recover from spelling mistakes. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]