Re: DROP DATABASE and prepared xacts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: alvherre(at)alvh(dot)no-ip(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP DATABASE and prepared xacts
Date: 2007-02-12 17:32:16
Message-ID: 11051.1171301536@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> Do we consider committing a transaction from another database a feature,
> and fix NOTIFY/LISTEN, or should COMMIT PREPARED throw an error if
> you're not connected to the same database?

Hmm ... if we were sure NOTIFY were the only sore spot I'd say fix it,
but probably safer to refuse to commit, instead.

> 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".

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-02-12 17:48:17 Re: DROP DATABASE and prepared xacts
Previous Message Weslee Bilodeau 2007-02-12 17:27:11 Re: Acclerating INSERT/UPDATE using UPS