PDO & pgsql?

From: 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

« previous php.general (#223926) next »