Postgres Pro
Downloads
Home   >   mailing lists

Re: psql hangs after "drop table ..." - Mailing list pgsql-novice

From Tom Lane
Subject Re: psql hangs after "drop table ..."
Date
Msg-id 25041.1077251441@sss.pgh.pa.us
Whole thread Raw
In response to psql hangs after "drop table ..."  (<kynn@panix.com>)
List pgsql-novice
Tree view 
<kynn@panix.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

pgsql-novice by date:

Previous
From: JWDougherty
Date:
Subject: pg_hba.conf problem
Next
From: daq
Date:
Subject: Re: [SQL] Row counts/data changes. Any catalog table that has this info?