X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 53DD09FA4A0 for ; Fri, 5 May 2006 22:44:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 56549-06 for ; Fri, 5 May 2006 22:44:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by postgresql.org (Postfix) with ESMTP id D5BC79F9806 for ; Fri, 5 May 2006 22:44:09 -0300 (ADT) Received: from panix3.panix.com (panix3.panix.com [166.84.1.3]) by mail1.panix.com (Postfix) with ESMTP id 36A8F597F6; Fri, 5 May 2006 21:44:08 -0400 (EDT) Received: (from kynn@localhost) by panix3.panix.com (8.11.6p3/8.8.8/PanixN1.1) id k461i8S04751; Fri, 5 May 2006 21:44:08 -0400 (EDT) Date: Fri, 5 May 2006 21:44:08 -0400 (EDT) Message-Id: <200605060144.k461i8S04751@panix3.panix.com> From: To: pgsql-admin@postgresql.org Subject: Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/60 X-Sequence-Number: 21592 When I run pg_dump I get this error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: permission denied for schema test pg_dump: The command was: LOCK TABLE test.__proc IN ACCESS SHARE MODE I can't find out what transaction is responsible for this lock. When I look at the pg_locks table, I see only two locks, and they both seem to be due to the fact that I am interacting with psql at the moment, and this interaction is in no way directed to the database I'm trying to dump. Is there a way for me to find out the transaction responsible for the lock that's causing the error message? If so, how can I kill this transaction? kj