Обсуждение: Drop table

Поиск
Список
Период
Сортировка

Drop table

От
Nageshwar Rao
Дата:
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

От
Michael Fuhr
Дата:
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/