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 E8879556EE for ; Wed, 23 Feb 2005 20:39:59 +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 29480-04 for ; Wed, 23 Feb 2005 20:39:54 +0000 (GMT) Received: from thea.sephie.org (h-67-100-183-100.nycmny83.covad.net [67.100.183.100]) by svr1.postgresql.org (Postfix) with ESMTP id 8C93C5521B for ; Wed, 23 Feb 2005 20:39:53 +0000 (GMT) Received: from [192.168.1.152] (unknown [192.168.1.152]) by thea.sephie.org (Postfix) with ESMTP id 900E07B0783; Wed, 23 Feb 2005 15:36:27 -0500 (EST) Message-ID: <421CEA17.2080706@nypost.com> Date: Wed, 23 Feb 2005 15:39:51 -0500 From: Heather Johnson User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ron Ellingson Cc: pgsql-php@postgresql.org Subject: Re: permission problems References: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> In-Reply-To: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> 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.424 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/25 X-Sequence-Number: 2999 Did you grant the relevant permissions on just the table, or on both the sequence and the table? You'll need to do both. Heather Johnson Senior Database Programmer New York Post Ron Ellingson wrote: > 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 > > Ron Ellingson > rellingson@satshot.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org