| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Multiple Xids in PGPROC? |
| Date: | 2004-05-05 04:30:23 |
| Message-ID: | 1083731423.54823.6.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2004-05-05 04:41:14 | Re: Multiple Xids in PGPROC? |
| Previous Message | Christopher Kings-Lynne | 2004-05-05 04:22:28 | Re: Multiple Xids in PGPROC? |