Postgres SQL Question. - Limitation exceeded?

[linuxdad]

OK, I have been running Postgres 8.1.18 from Mandriva Linux Corporate Server release 2006.0

So it's definitely time for an upgrade, and I have Installed Mageia 4.0 with Postgresql 9.3.

This issue is that when I attempt to run my Perl Scripts on the 9.3 server, I get a strange error:

Code: Select all

DBD::Pg::st execute failed: ERROR:  syntax error at or near ","
LINE 1: ...,action,thresh,discard,evirus,attach,enavirus,over,ssm,visiz...
                                                             ^ at ./Test-PgSQL.pl line 91.
DBD::Pg::st fetchrow_array failed: no statement executing at ./Test-PgSQL.pl line 92.


The Source of the Code is:

Code: Select all

$sth = $dbh->prepare("select filter,action,thresh,discard,evirus,attach,enavirus,over,ssm,visize,ssma,redhtml,qesh,qesb,overact,minscore,scanzip,greylist,use_from from configuration where customerid=1");

If I shorten the above to everything before the over variable, it runs perfectly.

Is there a reduction in the space for the selection variables? Do I need to change a configuration setting? Suggestions?

Thank you in advance.

[doktor5000]

You might be better of asking that in some perl or postgres forum, I suppose there aren't that much people around here with both experience
on postgres migration from 8 => 9 and with running perl scripts for queries against it. Although you never know ...

Although you could try asking on either the Mageia dev or discuss mailinglists:
https://ml.mageia.org/wwsympa-wrapper.fcgi/info/dev
https://ml.mageia.org/wwsympa-wrapper.fcgi/info/discuss