Syntax of transaction identifiers

Started by Peter Eisentrautover 20 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

Why are the transaction identifiers used in the 2PC commands lexical
strings rather than identifiers? Shouldn't database objects be
identifiers and strings be purely data objects? Or is there some
standard or precedent on that?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: Syntax of transaction identifiers

Peter Eisentraut <peter_e@gmx.net> writes:

Why are the transaction identifiers used in the 2PC commands lexical
strings rather than identifiers? Shouldn't database objects be
identifiers and strings be purely data objects? Or is there some
standard or precedent on that?

I proposed the same awhile back, but it was shot down --- there is
a standard out there somewhere, and it requires strings of 150 or so
characters for GIDs, so identifiers don't work. See the archives.

regards, tom lane