Re: SAVEPOINT SQL conformance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SAVEPOINT SQL conformance
Date
Msg-id 10233.1095543433@sss.pgh.pa.us
Whole thread Raw
In response to SAVEPOINT SQL conformance  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-hackers
"Michael Paesold" <mpaesold@gmx.at> writes:
> If the first example code is used (which I would use if I did not think
> about postgresql's exception), the subxact state stack in xact.c will grow
> and grow and grow... whereas in the case of compliance with the standard, it
> will not.

This is fairly irrelevant though, as the state stack entry is only a
small part of the resources consumed by an uncommitted subtransaction.
I don't really think it outweighs the argument you quoted about
accidental collisions of savepoint names causing problems.

On the other hand, we do have provisions in the code for savepoint
naming levels, and so maybe a better answer to the collision issue
is to support savepoint levels more completely.  (But that's not
standard either.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Michael Paesold"
Date:
Subject: SAVEPOINT SQL conformance
Next
From: Oliver Jowett
Date:
Subject: Re: SAVEPOINT SQL conformance