Re: psql hangs after "drop table ..."

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kynn(at)panix(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql hangs after "drop table ..."
Date: 2004-02-20 04:30:41
Message-ID: 25041.1077251441@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<kynn(at)panix(dot)com> writes:
> I'm trying to drop an empty table (0 records) using:
> testdb=> drop table empty_table;
> but psql just hangs indefinitely after I hit return.

Sounds to me like there's another session that has an open transaction
with a lock on that table.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message daq 2004-02-20 07:44:49 Re: [SQL] Row counts/data changes. Any catalog table that has this info?
Previous Message JWDougherty 2004-02-20 03:07:10 pg_hba.conf problem