Scott Marlowe wrote:
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <pg@dbginc.com> wrote:
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
Postgresql uses savepoints.
Savepoints do not provide the same functionality as nested or parallel transactions because you cannot commit a savepoint. If I need a second transaction I can always open a second connection so it is easy to get the behavior I need. Thanks.
Bill