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. No error
messages. (The table definitely exists; no other table refers to it.)

The only way out is to hit Ctrl-C; when I do this I get the message:

Cancel request sent
ERROR: Query was cancelled.
testdb=>

What's going on? What can I do to troubleshoot this problem?

Thanks!

kj

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

<kynn (AT) panix (DOT) com> writes:
Sounds to me like there's another session that has an open transaction
with a lock on that table.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)