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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
