Re: DROP DATABASE and prepared xacts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP DATABASE and prepared xacts
Date: 2007-02-12 16:23:35
Message-ID: 9660.1171297415@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> I think we should set things up so that prepared transactions are
> dropped when they concern a database being dropped. Opinions?

No. A prepared transaction is one that we have guaranteed we can commit
when the 2PC manager tells us to. Reneging on that commitment is
something the DBA can choose to do manually, but I disagree with doing
it automatically.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-02-12 16:26:24 Re: DROP DATABASE and prepared xacts
Previous Message Alvaro Herrera 2007-02-12 15:29:20 DROP DATABASE and prepared xacts