Tom Lane wrote:
>> Actually, I think we should completely separate the namespaces of the
>> global transaction identifiers, so that you could use the same gid in
>> two different databases without a conflict.
>
> Really? They're supposed to be "global".
Well yeah, the TM should be assigning globally unique ids to every
transaction. I don't trust all the TM implementations out there, and you
could even have two different TMs stepping on each others toes, but then
again I guess it's not really our problem as long as we give a nice
error message.
The XA spec recommends assigning transaction ids using the naming rules
specified for "OSI CCR atomic action identifiers". I don't know if it's
widely used in practice.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com