Re: Drop table - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Drop table
Date
Msg-id 20041207083113.GA53617@winnie.fuhr.org
Whole thread Raw
In response to Drop table  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
List pgsql-general
On Tue, Dec 07, 2004 at 01:20:07PM +0530, Nageshwar Rao wrote:

> Not able to drop a table,though nobody is accessing the table.I am able to
> insert the records and delete the records.When I give drop table it just
> hangs there .No error message.

Another transaction might be holding a lock on the table.  Have
you looked at pg_locks?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Nageshwar Rao
Date:
Subject: Drop table
Next
From: Daniel Martini
Date:
Subject: Re: When to encrypt