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.