Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP DATABASE always seeing database in use - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: DROP DATABASE always seeing database in use
Date
Msg-id 20080804140134.GA29797@winnie.fuhr.org
Whole thread Raw
In response to DROP DATABASE always seeing database in use  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: DROP DATABASE always seeing database in use  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Tree view 
On Mon, Aug 04, 2008 at 11:51:35AM +0100, Gregory Stark wrote:
> It seems there's something wrong with CheckOtherDBBackends() but I haven't
> exactly figured out what. There are no other sessions but drop database keeps
> saying "regression" is being accessed by other users.

Are any prepared transactions still open?

select * from pg_prepared_xacts;

-- 
Michael Fuhr

pgsql-hackers by date:

Previous
From: Jorgen Austvik - Sun Norway
Date:
Subject: Re: pg_regress inputdir
Next
From: Tom Lane
Date:
Subject: Re: unnecessary code in_bt_split