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

From
Subject psql hangs after "drop table ..."
Date
Msg-id 200402200023.i1K0NTU03421@panix3.panix.com
Whole thread Raw
Responses Re: psql hangs after "drop table ..."  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice



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

pgsql-novice by date:

Previous
From: daq
Date:
Subject: Re: [SQL] crosstabs
Next
From: joseph speigle
Date:
Subject: commenting sql code