Re: Database in use?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Carol Walter <walterc(at)indiana(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database in use?
Date: 2009-03-04 22:30:10
Message-ID: 8353.1236205810@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter <walterc(at)indiana(dot)edu> wrote:
>> This database is one that I created just a few hours ago just to test some
>> things myself. There can be no one in it except me.

> Correct me if I'm wrong, but isn't that enough ((just you) to cause
> the drop database to fail?

If you try to drop the current session's database, you get a different
error message.

regression=# drop database regression;
ERROR: cannot drop the currently open database

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lee Azzarello 2009-03-04 23:23:18 Re: warm standby, pg_standby, invalid checkpoint record
Previous Message Yauheni Labko 2009-03-04 22:22:14 Re: standby waiting for what?