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@xxxxxxxxxxxx email
519.745.7374 office
519.897.2552 mobile
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get Mozilla Firefox at
http://spreadfirefox.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
