Re: DROP DATABASE always seeing database in use

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Postgres <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP DATABASE always seeing database in use
Date: 2008-08-04 14:01:35
Message-ID: 20080804140134.GA29797@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jorgen Austvik - Sun Norway 2008-08-04 14:13:09 Re: pg_regress inputdir
Previous Message Alvaro Herrera 2008-08-04 13:30:59 Re: DROP DATABASE always seeing database in use