DROP DATABASE and prepared xacts - Mailing list pgsql-hackers

From Alvaro Herrera
Subject DROP DATABASE and prepared xacts
Date
Msg-id 20070212152920.GA24986@alvh.no-ip.org
Whole thread Raw
Responses Re: DROP DATABASE and prepared xacts  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DROP DATABASE and prepared xacts  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
I was just testing autovac once more, and happened to Ctrl-C the
regression run in the prepared_xacts test.  Upon starting Postmaster
again, I see this:

LOG:  recovering prepared transaction 14372
LOG:  recovering prepared transaction 14377


Then, I reran "make check", and got

============== dropping database "regression"         ==============
ERROR:  database "regression" is being accessed by other users
command failed: "/pgsql/install/00head/bin/psql" -X -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"


I think we should set things up so that prepared transactions are
dropped when they concern a database being dropped.  Opinions?

Any takers? ;-)

-- 
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"La persona que no quería pecar / estaba obligada a sentarseen duras y empinadas sillas    / desprovistas, por ciertode
blandosatenuantes"                          (Patricio Vogel)
 


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: tsearch2: enable non ascii stop words with C locale
Next
From: Tom Lane
Date:
Subject: Re: DROP DATABASE and prepared xacts