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 [EMAIL PROTECTED] -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Mon 12/17/2007 4:11 PM To: Tena Sakai Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] How would I "close" a atble? "Tena Sakai" <[EMAIL PROTECTED]> 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
