Hi I am in the process of migrating a web application from a small linux server (Fedora 2, AMD processor), to a new larger box running RHEL 4, AMD64.
The version of postgres (8.1.3), DBD::Pg(1.47) and everything else (data and application) is the same. However, on the new server, two reports are consistently showing the following error ERROR: prepared statement "dbdpg_1" does not exist The two reports have multiple cursors (3 levels) and have never had a problem before. I have error checked the cost, and there are no errors prior to calling 'execute', but the execute fails with the above error. A test version of one report runs without error from the command, but when invoked via ModPerl/Apache we get the above error. Has anyone seen problems before with Prepared statements failing, and know of a solution? Thanx Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599
