Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.0b4

Bug #15056 tableInfo does not work with pgsql schemas
Submitted: 2008-11-17 09:39 UTC Modified: 2008-11-23 13:02 UTC
From: matejpuntar Assigned: quipo
Status: Closed Package: MDB2_Driver_pgsql (version 1.4.1)
PHP Version: 5.2.6 OS: Mac os X 10.5
Roadmaps: (Not assigned)    
Subscription  


 [2008-11-17 09:39 UTC] matejpuntar (Matej Puntar)
Description: ------------ PEAR error message: MDB2 Error: not found user info: [Error message: it was not specified an existing table column] It works great in public Schema: $db2->tableInfo('table_name') http://www.postgresql.org/docs/current/static/ddl-schemas.html Test script: --------------- $db2->loadModule('Reverse'); print_r($db2->tableInfo('schema_name.table_name')); Expected result: ---------------- Array ( [0] => Array ( [notnull] => 1 [nativetype] => varchar [length] => 255 [fixed] => [default] => [type] => varchar [mdb2type] => text [name] => username [table] => auth [flags] => not_null ) [1] => Array ( [notnull] => [nativetype] => varchar [length] => 255 [fixed] => [default] => [type] => varchar [mdb2type] => text [name] => password [table] => auth [flags] => ) ... Actual result: -------------- PEAR error message: MDB2 Error: not found user info: [Error message: it was not specified an existing table column] MDB2_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => -4 [message] => MDB2 Error: not found [userinfo] => [Error message: it was not specified an existing table column] [backtrace] => Array ( [0] => Array ( [file] => /Applications/MAMP/bin/php5/lib/php/MDB2.php [line] => 973 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: not found [1] => -4 [2] => 16 [3] => errhndl [4] => [Error message: it was not specified an existing table column] ) ) [1] => Array ( [file] => /Applications/MAMP/bin/php5/lib/php/PEAR.php [line] => 574 [function] => MDB2_Error [class] => MDB2_Error [object] => MDB2_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -4 [1] => 16 [2] => errhndl [3] => [Error message: it was not specified an existing table column] ) ) ...

Comments

 [2008-11-23 13:02 UTC] quipo (Lorenzo Alberton)
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.