Re: Drop table

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Drop table
Date: 2004-12-07 08:31:13
Message-ID: 20041207083113.GA53617@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

  • Drop table at 2004-12-07 07:50:07 from Nageshwar Rao

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Martini 2004-12-07 08:31:37 Re: When to encrypt
Previous Message Per Jensen 2004-12-07 08:25:20 Re: Index scan vs. Seq scan on timestamps