#33514 [Opn->Bgs]: Postgres dll not included in PECL

ID: 33514 Updated by: sniper@php.net Reported By: francoisdanielloubser at hotmail dot com -Status: Open +Status: Bogus Bug Type: PostgreSQL related Operating System: Windows XP PHP Version: 5.0.4 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2005-06-30 15:15:08] francoisdanielloubser at hotmail dot com According to the website documentation the dll is no longer included with PHP as in PHP 4, but included instead with PECL. Even if it is included I can't find it anywhere if I search for it. What is the default directory for it? ------------------------------------------------------------------------ [2005-06-30 11:52:32] tony2001@php.net php_pg_sql.dll is bundled with main PHP distribution, you're looking for it in wrong place. Btw, PECL bugs should be reported here: http://pecl.php.net/bugs/ ------------------------------------------------------------------------ [2005-06-30 11:33:17] francoisdanielloubser at hotmail dot com Description: ------------ The PECL distribution for PHP 5.0.4 does not include the postgres dll. Instead it include's another one that does not work. Even if I rename the dll included to be the same as the name in the ini file and copy it to the windows system directory, I still get the same error. Reproduce code: --------------- <?php /* * Define PostgreSQL database server connect parameters. */ define('PGHOST','10.0.0.218'); define('PGPORT',5432); define('PGDATABASE','example'); define('PGUSER', 'root'); define('PGPASSWORD', 'nopass'); define('PGCLIENTENCODING','UNICODE'); define('ERROR_ON_CONNECT_FAILED','Sorry, can not connect the database server now!'); /* * Merge connect string and connect db server with default parameters. */ pg_pconnect('host=' . PGHOST . ' port=' . PGPORT . ' dbname=' . PGDATABASE . ' user=' . PGUSER . ' password=' . PGPASSWORD); /* * generate sql statements to call db-server-side stored procedure(or function) * @parameter string $proc stored procedure name. * @parameter array $paras parameters, 2 dimensions array. * @return string $sql = 'select "proc"(para1,para2,para3);' * @example pg_prepare('userExists', * array( * array('userName','chin','string'), * array('userId','7777','numeric') * ) * ) */ function pg_prepare($proc, $paras) { $sql = 'select "' . $proc . '"('; $sql .= $paras[0][2] == 'numeric' ? $paras[0][1] : "'" . str_replace("'","''",$paras[0][1]) . "'"; $len = count($paras); for ($i = 1; $i < $len; $i ++) { $sql .= ','; $sql .= $paras[$i][2] == 'numeric' ? $paras[$i][1] : "'" . str_replace("'","''",$paras[$i][1]) . "'"; } $sql .= ');'; return $sql; } ?> Expected result: ---------------- Standard example Actual result: -------------- Error cannot find dll. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=33514&edit=1