Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7UEp1f44637 for ; Thu, 30 Aug 2001 10:51:01 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from star.rila.bg (star.rila.bg [212.39.75.32]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7SFE0f93922 for ; Tue, 28 Aug 2001 11:14:01 -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 f7SFFTq01398 for ; Tue, 28 Aug 2001 18:15:30 +0300 (EEST) (envelope-from vlady@star.rila.bg) Message-Id: <200108281515.f7SFFTq01398@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: Problem with sequences Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 28 Aug 2001 18:15:29 +0300 X-Archive-Number: 200108/366 X-Sequence-Number: 4616 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