| 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 14:39 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) | ||
[2008-11-17 14: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 18: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.