|P is for Practical|
Need help with DBD::Pgby Miguel (Friar)
|on Feb 23, 2005 at 17:05 UTC||Need Help??|
Miguel has asked for the
wisdom of the Perl Monks concerning the following question:
I wrote a Perl program wich uses PostgreSQL. This program was running well for months until yesterday, when my SysAdmin upgraded the DBD::Pg module for the current version (1.40).
Now, where I have
Raises 2 errors:
If I delete the first line LOCK TABLE tabreserves IN SHARE MODE;, raises another error.
Needless to say that I have _many_ statements wich uses the same structure - e.g. multiple commands in a prepared statement and not casting expressions, since that wasn't mandatory before.
When we (me and the sysadmin) saw the errors we thought: "well... time to upgrade to PostgreSQL 8!". We were using 7.4. We did the upgrade. But the errors persist.
What am I missing here? Do I really need to cast expressions? and why can't I use multiple statements now?