Re: How would I "close" a atble?

Thank you, Tom!

> Some other session holding an exclusive lock on the table, perhaps?

That is exactly the case.
I see what I must do. Many thanks.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Mon 12/17/2007 4:11 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] How would I "close" a atble?

"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)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