Drop table
Started by Nageshwar Raoover 21 years ago2 messagesgeneral
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.
any specific reasons
thx
Re: Drop table
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/