Received: from star.rila.bg ([194.141.1.32]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7T8bbf33956 for ; Wed, 29 Aug 2001 04:37:37 -0400 (EDT) (envelope-from vlady@star.rila.bg) Received: from star.rila.bg (vlady@localhost [127.0.0.1]) by star.rila.bg (8.11.4/8.11.4) with ESMTP id f7T7e0q04704 for ; Wed, 29 Aug 2001 10:40:00 +0300 (EEST) (envelope-from vlady@star.rila.bg) Message-Id: <200108290740.f7T7e0q04704@star.rila.bg> X-Mailer: exmh version 2.4 05/15/2001 with nmh-1.0.3 To: pgsql-sql@postgresql.org From: "Vladimir Terziev" Subject: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 29 Aug 2001 10:40:00 +0300 X-Archive-Number: 200108/347 X-Sequence-Number: 4597 Hi, I'm writing a script, which has to retrieve a next value from a sequnce. I use mod_perl, DBI and DBD::Pg version 0.98. I notice that when I execute "select nextval('sequence_name'::text) AS sname;", via DBI, the value of sequence is updated, but the mod_perl returns "DBD::Pg::st execute failed: ERROR: sequence_name.nextval: you don't have permissions to set sequence" The above command is executed sucssesfuly in psql and returns the desire result. Does anybody has an idea what is the problem ? Vladimir