Re: How would I "close" a atble?

"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