#44789 [Opn->Bgs]: pg_execute() doesn't work (as documented?)

ID: 44789 User updated by: php at benjaminschulz dot com Reported By: php at benjaminschulz dot com -Status: Open +Status: Bogus Bug Type: *General Issues Operating System: osx PHP Version: 5.2CVS-2008-04-20 (CVS) New Comment: sorry. Previous Comments: ------------------------------------------------------------------------ [2008-04-20 21:14:32] php at benjaminschulz dot com Description: ------------ This sample code is a customized version of the sample from http://php.net/pg_execute Reproduce code: --------------- $dbconn = pg_connect(...) // Prepare a query for execution $result = pg_prepare($dbconn, "my_query", 'SELECT $1'); // Execute the prepared query. Note that it is not necessary to escape // the string "Joe's Widgets" in any way $result = pg_execute($dbconn, "my_query", array("Joe's Widgets")); // Execute the same prepared query, this time with a different parameter $result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes")); Expected result: ---------------- No errors ;) Actual result: -------------- Warning: pg_prepare(): Query failed: ERROR: could not determine data type of parameter $1 in ... Warning: pg_execute(): Query failed: ERROR: prepared statement "my_query" does not exist in ... Warning: pg_execute(): Query failed: ERROR: prepared statement "my_query" does not exist in ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=44789&edit=1