[SQL] Problem with sequences

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

[SQL]

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 f

[SQL] Large text insertion

Can anybody tell me, how I can insert text data larger then 20k in database wihtout using large objects?