X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DBE9329C7B for ; Sun, 19 Sep 2004 22:16:49 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11239-10 for ; Sun, 19 Sep 2004 21:16:43 +0000 (GMT) Received: from a.mx.zettai.net (a.mx.zettai.net [207.58.154.6]) by svr1.postgresql.org (Postfix) with ESMTP id 3598D329E6F for ; Sun, 19 Sep 2004 22:16:42 +0100 (BST) Received: (qmail 91313 invoked by uid 1012); 19 Sep 2004 21:16:41 -0000 Received: from robb@acm.org by beta.zettai.net by uid 89 with qmail-scanner-1.22 (clamdscan: 0.70. spamassassin: 2.63. Clear:RC:1(67.171.31.36):. Processed in 0.114219 secs); 19 Sep 2004 21:16:41 -0000 Received: from unknown (HELO ?192.168.0.100?) (robert@greenfabrik.com@67.171.31.36) by 0 with (DHE-RSA-AES256-SHA encrypted) SMTP; 19 Sep 2004 21:16:41 -0000 Message-ID: <414DF72F.8010906@acm.org> Date: Sun, 19 Sep 2004 14:16:31 -0700 From: Robb Shecter User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: All ops on one particular table cause a hang? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/166 X-Sequence-Number: 14869 I just created a table, but now cannot access it or even drop it. I can access all the other tables in the database just fine. But any client command or app (like pg_dumpall) that references this new table hang. I looked through the docs and FAQ for a any mention of this, or a way to repair or drop a table some other way, but can't find it. Thanks for any ideas. Robb