Posted by Jeffrey Sambells on 10/11/05 21:52

I've been playing with the new PDO stuff in PHP 5.1 and am having
trouble running queries on our database.

I've installed PDO and pdo_pgsql through the pear/pecl installer and
am trying to use a PostgreSQL 8.x DB. The connection is created fine,
logged in etc. but when I try to run a query I get a generic SQL
HY000 error. On the database server, the postgres log reports:


ERROR: prepared statement "pdo_pgsql_stmt_081ed42c" does not exist


and here's a bit of additional debug stuff from PHP and PDO:


PDO_ATTR_ERRMODE: 0
PDO_ATTR_CLIENT_VERSION: 8.0.2
PDO_ATTR_CONNECTION_STATUS: Connection OK; waiting to send.
PDO_ATTR_SERVER_VERSION: PostgreSQL 8.0.3 on i686-pc-linux-gnu,
compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)

and errorInfo() returns:

array(3) {
[0]=>
string(5) "HY000"
[1]=>
int(7)
[2]=>
string(0) ""
}



I am thinking it is something in the PDO_pgsql extension but thought
I'd ask if anyone has any ideas why it's not working?

Thanks.

-Jeff

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jeffrey Sambells
Director of Research and Development
Zend Certified Engineer (ZCE)

We-Create Inc.
jeff@wecreate.com email
519.745.7374 office
519.897.2552 mobile

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get Mozilla Firefox at
http://spreadfirefox.com

[Back to original message]