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 6207456398 for ; Wed, 23 Feb 2005 20:24:34 +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 23227-08 for ; Wed, 23 Feb 2005 20:24:24 +0000 (GMT) Received: from arlene.ideaone.net (mail.ideaone.net [64.21.232.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7F768562D6 for ; Wed, 23 Feb 2005 20:24:23 +0000 (GMT) Received: from vesuvius.fargo-office.satshot.com (ideaone-245-2.ideaone.net [64.21.245.2]) by arlene.ideaone.net (8.12.9/8.12.9) with ESMTP id j1NKOVYK025777 for ; Wed, 23 Feb 2005 14:24:31 -0600 Subject: permission problems From: Ron Ellingson To: pgsql-php@postgresql.org Content-Type: text/plain Message-Id: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 23 Feb 2005 14:24:17 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/24 X-Sequence-Number: 2998 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