Re: [BUGS] Behavior of identically-named savepoints

2009-02-03 Thread Joshua Tolley
On Tue, Feb 03, 2009 at 11:31:31AM -0700, Joshua Tolley wrote: > Unless, of course, > I'm missing something. Yep, I was missing something. I didn't realize ROLLBACK TO SAVEPOINT didn't destroy the newer savepoint like RELEASE SAVEPOINT does. Adding RELEASE SAVEPOINT calls to my test script makes i

[BUGS] Behavior of identically-named savepoints

2009-02-03 Thread Joshua Tolley
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.