Edit report at http://bugs.php.net/bug.php?id=54607&edit=1
ID: 54607 Updated by: il...@php.net Reported by: sesebs at gmail dot com Summary: Warning on pg_connection_status() -Status: Open +Status: Bogus Type: Bug Package: PostgreSQL related Operating System: Ubuntu 8.04 PHP Version: 5.2.6 Block user comment: N Private report: N New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php WHen the connection parameter is not a valid resource, the error comes from param validation... Previous Comments: ------------------------------------------------------------------------ [2011-04-29 15:47:20] felipecg00 at gmail dot com You are right. I have just tested it in a postgresql server right now and I don't get a warning from pg_connection_status(). Still, I am using version 5.3.3 of PHP. But a strange behavior, is that my pg_connection_status returns boolean FALSE if resource is not valid, which is different from 0 of PGSQL_CONNECTION_BAD: $valid_resource = pg_connect('host=~ valid string here'); $invalid_resource = null; var_dump( pg_connection_status( $valid_resource ) ); // int(0) as expected var_dump( pg_connection_status( $invalid_resource ) ); // bool(false) var_dump( PGSQL_CONNECTION_BAD ); // int(1) different from bool(false) var_dump( PGSQL_CONNECTION_OK ); // int(0) as expected ------------------------------------------------------------------------ [2011-04-29 10:31:36] sesebs at gmail dot com If the resource is not a valid PostgreSql link resource, pg_connection_status() return PGSQL_CONNECTION_BAD but in my case it generate a warning more. I'm catching the warning with a personalized error handler but I prefer keep the php error handler with a error_reporting() set to E_ALL. Is There is a solution to verify my connection without generate a warning ? Thanks. ------------------------------------------------------------------------ [2011-04-27 20:16:10] felipecg00 at gmail dot com Seems like the problem is the resource $conn and not the function pg_connection_status(). It's like the function couldn't use that resource to do what it must to return the expected value. ------------------------------------------------------------------------ [2011-04-27 12:08:14] sesebs at gmail dot com Not PHP 5.3.6 but 5.2.6 ------------------------------------------------------------------------ [2011-04-26 15:30:10] sesebs at gmail dot com Description: ------------ In order to verify my connection to PostgreSql, I use PG_CONNECTION_STATUS(). When I try to check my connection, I have a warning who said : "pg_connection_status(): 103 is not a valid PostgreSQL link resource". PG_CONNECTION_STATUS() should return just PGSQL_CONNECTION_BAD if the connection is not a valid PostgreSQL link ressource. Why there is a warning who appears ? Test script: --------------- $state = pg_connection_status($conn); if ($state === PGSQL_CONNECTION_OK) { return true; } Actual result: -------------- pg_connection_status(): 103 is not a valid PostgreSQL link resource ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=54607&edit=1
