2009/10/16 Tom Lane <t...@sss.pgh.pa.us> > =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryz...@gmail.com> 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 > about that is here: > http://archives.postgresql.org/pgsql-hackers/2005-05/msg01292.php > > We could conceivably allow an identifier too in PREPARE TRANSACTION, > but I think that that might be more dangerous than helpful, because > of the implicit case folding for identifiers. 'XX' and 'xx' are > distinct but XX and xx wouldn't be. There are a few other places > where we allow strings and identifiers interchangeably, but AFAIR > they are all places where case doesn't matter. > > makes sense. Cheers Tom.
-- GJ
