Re: [GENERAL] savepoint name vs prepared transaction name

2009-10-16 Thread Grzegorz Jaśkiewicz
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

Re: [GENERAL] savepoint name vs prepared transaction name

2009-10-16 Thread 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 literals. The relevant discussion a

[GENERAL] savepoint name vs prepared transaction name

2009-10-16 Thread Grzegorz Jaśkiewicz
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