Re: Can't drop table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hima Surapaneni <hbsur1(at)student(dot)monash(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can't drop table
Date: 2006-07-03 03:23:41
Message-ID: 22479.1151897021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hima Surapaneni <hbsur1(at)student(dot)monash(dot)edu> writes:
> The query was successful. But when I try to drop or alter the table, it just hangs without echoing any error message. I have 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Penchalaiah P. 2006-07-03 10:13:34 hi i need to connect database from my system to another system
Previous Message Richard Broersma Jr 2006-07-03 02:30:00 Re: Can't drop table