Skip site navigation (1) Skip section navigation (2)

psql hangs after "drop table ..."

From: <kynn(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: psql hangs after "drop table ..."
Date: 2004-02-20 00:23:29
Message-ID: 200402200023.i1K0NTU03421@panix3.panix.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: joseph speigleDate: 2004-02-20 01:13:49
Subject: commenting sql code
Previous:From: BobDate: 2004-02-19 22:07:10
Subject: Slow subquery on large dataset

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group