Re: DROP DATABASE always seeing database in use

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Postgres" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP DATABASE always seeing database in use
Date: 2008-08-04 15:28:45
Message-ID: 877iaw6bpu.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Michael Fuhr" <mike(at)fuhr(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-08-04 15:29:41 Re: DROP DATABASE always seeing database in use
Previous Message Tom Lane 2008-08-04 15:22:41 Re: Parsing of pg_hba.conf and authentication inconsistencies