Behavior of identically-named savepoints

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Behavior of identically-named savepoints
Date: 2009-02-03 18:31:32
Message-ID: 20090203183131.GA7082@eddie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The SAVEPOINT documentation says that a new savepoint created with the
same name as an existing savepoint masks but does not destroy the old
savepoint, and rolling back to the savepoint will then make the old
savepoint available for RELEASE SAVEPOINT and ROLLBACK TO SAVEPOINT
calls. 8.3.5 and my 8.4devel (built a few days ago) don't follow this
behavior, as demonstrated with the attached script. Unless, of course,
I'm missing something.

- Josh / eggyknap

Attachment Content-Type Size
testsavepoint.sql text/plain 617 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joshua Tolley 2009-02-03 18:45:23 Re: Behavior of identically-named savepoints
Previous Message Tom Lane 2009-02-03 17:43:22 Re: BUG #4638: Bug with Geometry in Array