Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3E6T4824247 for ; Sat, 14 Apr 2001 02:29:04 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3E4tG809452 for ; Sat, 14 Apr 2001 00:55:16 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f3E4j5c84804 for pgsql-sql@postgresql.org; Sat, 14 Apr 2001 00:45:05 -0400 (EDT) (envelope-from news) Message-ID: <3AD7D623.E0D37494@optusnet.com.au> Date: Sat, 14 Apr 2001 14:46:27 +1000 From: Ian Pulsford X-Mailer: Mozilla 4.74 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.sql Subject: nobody user can't nextval('phone_id_seq') Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 15 To: pgsql-sql@postgresql.org X-Archive-Number: 200104/221 X-Sequence-Number: 2571 Hi, Newbie needs help. I have a small web-based phonebook app using php and postgresql 7.02. It seems the nobody (apache) user can delete, update, add anything except increment the 'id' sequence. I don't think it's the code (cut and pasted from a tutorial) because the pgsql user can increment it. Any help appreciated. IanP -- "Dear someone you've never heard of, how is so-and-so. Blah blah. Yours truly, some bozo." - Homer Simpson