X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79060562D6 for ; Wed, 23 Feb 2005 20:45:24 +0000 (GMT) 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 32047-01 for ; Wed, 23 Feb 2005 20:45:22 +0000 (GMT) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 775C5554D6 for ; Wed, 23 Feb 2005 20:45:21 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id D37DD11E25; Wed, 23 Feb 2005 17:42:41 -0300 (ART) Received: from bugs.unl.edu.ar ([127.0.0.1]) by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15386-06; Wed, 23 Feb 2005 17:42:41 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id BACC3125C2; Wed, 23 Feb 2005 17:42:40 -0300 (ART) From: =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= To: Ron Ellingson Subject: Re: permission problems Date: Wed, 23 Feb 2005 17:42:34 -0300 User-Agent: KMail/1.7.1 Cc: pgsql-php@postgresql.org References: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> In-Reply-To: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200502231742.34665.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at bugs.unl.edu.ar X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.157 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/26 X-Sequence-Number: 3000 El Mi=E9 23 Feb 2005 17:24, Ron Ellingson escribi=F3: > I am having a problem adding a row to a postgresql table with a sequence > as a primary key using pg_query. I receive an error, "permission denied > for sequence mytable_tid_seq". I have set the permissions for the user > from all which did not work to insert, update and select which did not > work. Can you help. Thanks Did you check the permissions of the sequence? =2D-=20 17:40:04 up 164 days, 7:34, 3 users, load average: 1.43, 1.36, 0.97 =2D---------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral =2D----------------------------------------------------------------