Postgres Pro
Downloads
Home   >   mailing lists

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

From Gregory Stark
Subject Re: DROP DATABASE always seeing database in use
Date
Msg-id 877iaw6bpu.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: DROP DATABASE always seeing database in use  (Michael Fuhr <mike@fuhr.org>)
Responses Re: DROP DATABASE always seeing database in use  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
"Michael Fuhr" <mike@fuhr.org> writes:

> 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?

Uh, yes, I did notice that but didn't put two and two together. That does make
sense now that you mention it.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production
Tuning

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parsing of pg_hba.conf and authentication inconsistencies
Next
From: Gregory Stark
Date:
Subject: Re: DROP DATABASE always seeing database in use