Re: DROP DATABASE and prepared xacts - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DROP DATABASE and prepared xacts
Date
Msg-id 9660.1171297415@sss.pgh.pa.us
Whole thread Raw
In response to DROP DATABASE and prepared xacts  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: DROP DATABASE and prepared xacts
Next
From: Heikki Linnakangas
Date:
Subject: Re: DROP DATABASE and prepared xacts