2009/10/16 Tom Lane
> =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> > Is there any reason, why I can't put quotes around name of savepoint, but
> I
> > have/can do this for prepare transaction ?
>
> Savepoint names are identifiers; the SQL spec says so. Prepared
> transaction GIDs are string l
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> Is there any reason, why I can't put quotes around name of savepoint, but I
> have/can do this for prepare transaction ?
Savepoint names are identifiers; the SQL spec says so. Prepared
transaction GIDs are string literals. The relevant discussion
a
Is there any reason, why I can't put quotes around name of savepoint, but I
have/can do this for prepare transaction ?
Ie:
SAVEPOINT 'foo'; --- doesn't work
SAVEPOINT foo; --- all grand
PREPARE TRANSACTION 'foo'; --- grand
PREPARE TRANSACTION foo; refuses to work.
It is quite confusing, I feel l