PDO & pgsql?
| From: | Jeffrey Sambells | Date: | Tue, 11 Oct 2005 18:52:12 +0000 |
| Subject: | PDO & pgsql? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-223926@lists.php.net to get a copy of this message | ||
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