Postgres Pro
Downloads
Home   >   mailing lists

Re: How would I "close" a atble? - Mailing list pgsql-admin

From Tom Lane
Subject Re: How would I "close" a atble?
Date
Msg-id 27986.1197936710@sss.pgh.pa.us
Whole thread Raw
In response to How would I "close" a atble?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
Tree view 
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> I have a weired situation.  Out of 17 tables which
> comprise a database, one of them refuses to talk to
> me.  When I issue:
>   select * from marker;
> it hangs.

Some other session holding an exclusive lock on the table, perhaps?
Have you looked into pg_locks for matches to that table?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: How would I "close" a atble?
Next
From: "Tena Sakai"
Date:
Subject: Re: How would I "close" a atble?