Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C61CE2E0048 for ; Mon, 17 Dec 2007 20:11:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 82050-05 for ; Mon, 17 Dec 2007 20:11:49 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9B0DD2E00E4 for ; Mon, 17 Dec 2007 20:11:53 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBI0BobV027987; Mon, 17 Dec 2007 19:11:50 -0500 (EST) To: "Tena Sakai" cc: pgsql-admin@postgresql.org Subject: Re: How would I "close" a atble? In-reply-to: References: Comments: In-reply-to "Tena Sakai" message dated "Mon, 17 Dec 2007 15:38:57 -0800" Date: Mon, 17 Dec 2007 19:11:50 -0500 Message-ID: <27986.1197936710@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/153 X-Sequence-Number: 27670 "Tena Sakai" 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