Re: [SQL] Problem with sequences

2001-08-30 Thread Josh Berkus
Vladimir, > 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" Your issue is eit

[SQL] Problem with sequences

2001-08-30 Thread Vladimir Terziev
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