Thread: Syntax of transaction identifiers

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/

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