Re: DROP DATABASE and prepared xacts

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> 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.

If we did that then it'd foreclose the possibility of committing a
prepared xact from a connection in a different DB.  Even though I'm a
bit worried about whether we'd have bugs in doing such a thing, I don't
really want to define it to be impossible.  "Not implemented" is a lot
different from "impossible because of bad system design".
        regards, tom lane