http://pear.php.net/bugs/search.php?cmd=display&package_name%5B0%5D=MDB2_Driver_pgsql Search Results en-us pear-webmaster@lists.php.net pear-webmaster@lists.php.net hourly 1 2000-01-01T12:00+00:00 http://pear.php.net/gifs/pearsmall.gif http://pear.php.net/bugs http://pear.php.net/bugs/12931 MDB2_Driver_pgsql Feature/Change Request Reported by caphrim007 2008-01-18T12:07:42+00:00 PHP: 5.2.5 OS: RHEL 4 Package Version: 1.4.1 Description: ------------ I was hoping that CASCADE functionality could be added to the pgsql manager manager so that it would also drop tables that inherit from a table being dropped.]]> MDB2_Driver_pgsql Feature/Change Request Reported by caphrim007 2008-01-18T12:07:42+00:00 PHP: 5.2.5 OS: RHEL 4 Package Version: 1.4.1 Description: ------------ I was hoping that CASCADE functionality could be added to the pgsql manager manager so that it would also drop tables that inherit from a table being dropped.]]> 2008-01-18T12:07:42+00:00 caphrim007 at gmail dot com MDB2_Driver_pgsql Feature/Change Request http://pear.php.net/bugs/11802 MDB2_Driver_pgsql Feature/Change Request Reported by pberry 2007-08-08T20:27:51+00:00 PHP: Irrelevant OS: N/A Package Version: 1.4.1 Description: ------------ Neither the driver or MDB2 contains a way to manually check if a connection is still active and whether or not it's busy. Two methods that I've added to MDB2_Driver_pgsql are connectionIsBusy() and pingConnection(), it would be nice if these or something similar could be rolled into main. Test script: --------------- function connectionIsBusy(){ if(pg_connection_busy($this->connection)){ return TRUE ; } } function pingConnection(){ if(pg_connection_status($this->connection) === PGSQL_CONNECTION_OK){ return TRUE ; } }]]> MDB2_Driver_pgsql Feature/Change Request Reported by pberry 2007-08-08T20:27:51+00:00 PHP: Irrelevant OS: N/A Package Version: 1.4.1 Description: ------------ Neither the driver or MDB2 contains a way to manually check if a connection is still active and whether or not it's busy. Two methods that I've added to MDB2_Driver_pgsql are connectionIsBusy() and pingConnection(), it would be nice if these or something similar could be rolled into main. Test script: --------------- function connectionIsBusy(){ if(pg_connection_busy($this->connection)){ return TRUE ; } } function pingConnection(){ if(pg_connection_status($this->connection) === PGSQL_CONNECTION_OK){ return TRUE ; } }]]> 2007-08-08T20:27:51+00:00 pberry at stellaconcepts dot com MDB2_Driver_pgsql Feature/Change Request http://pear.php.net/bugs/7059 MDB2_Driver_pgsql Feature/Change Request Reported by sacher@... 2006-03-08T05:39:04+00:00 PHP: 5.0.4 OS: Linux SuSE10.0 i386 Package Version: Description: ------------ The documentation says that a sequence will automatically be created on nextID(.., true). nextID returns a DB_Error like this: DB Error: unknown error -1 SELECT NEXTVAL('test_seq') [nativecode=FEHLER: Relation »test_seq« existiert nicht] (relation does not exist) Reason seems to be the return code of the used PostgreSQL which is not the one expected by nextID(). If uncomment the condition in DB/pqsql.php Line 681 $result->getCode() == DB_ERROR_NOSUCHTABLE everything works fine. Used db is PostgreSQL 7.4.8]]> MDB2_Driver_pgsql Feature/Change Request Reported by sacher@... 2006-03-08T05:39:04+00:00 PHP: 5.0.4 OS: Linux SuSE10.0 i386 Package Version: Description: ------------ The documentation says that a sequence will automatically be created on nextID(.., true). nextID returns a DB_Error like this: DB Error: unknown error -1 SELECT NEXTVAL('test_seq') [nativecode=FEHLER: Relation »test_seq« existiert nicht] (relation does not exist) Reason seems to be the return code of the used PostgreSQL which is not the one expected by nextID(). If uncomment the condition in DB/pqsql.php Line 681 $result->getCode() == DB_ERROR_NOSUCHTABLE everything works fine. Used db is PostgreSQL 7.4.8]]> 2006-03-12T04:13:56+00:00 sacher at manetmail dot de MDB2_Driver_pgsql Feature/Change Request