Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't drop table - Mailing list pgsql-sql

From Tom Lane
Subject Re: Can't drop table
Date
Msg-id 22479.1151897021@sss.pgh.pa.us
Whole thread Raw
In response to Can't drop table  (Hima Surapaneni <hbsur1@student.monash.edu>)
List pgsql-sql
Tree view 
Hima Surapaneni <hbsur1@student.monash.edu> writes:
> The query was successful. But when I try to drop or alter the table, it just hangs without echoing any error message.
Ihave to cancel the query to get out.
 

Sounds like there's some open transaction with a lock on the table.
The pg_locks view might help you figure out which one.
        regards, tom lane

pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Can't drop table
Next
From: "Penchalaiah P."
Date:
Subject: hi i need to connect database from my system to another system