Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Add psql option: -1 or --single-transaction - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Add psql option: -1 or --single-transaction
Date
Msg-id 17540.1139935728@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Add psql option: -1 or --single-transaction  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-committers
Tree view 
Simon Riggs <simon@2ndquadrant.com> writes:
> [It's a shame we don't support nested BEGINs, for use in nested function
> calls. I guess we took that out infavour of SAVEPOINTs? I seem to
> remember some idiot (me wasn't it?) suggesting we should do that.]

I still think that was probably the right move, though.  With nested
BEGIN/COMMIT it'd be way too easy to get confused about how many levels
deep you are.  The savepoint syntax at least provides names for the
levels.  (Not that we have any mechanism to expose the state to you :-()

            regards, tom lane

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add some missing vacuum_delay_point calls in GIST vacuuming.
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Move btbulkdelete's vacuum_delay_point() call to a place in the