PEAR is discontinued

This is a static archive preserving historical releases and metadata. No new packages or updates will be published. For updates to existing packages, or to publish new packages, please use Composer and Packagist.

Home » Database » DB » Bug #7131

pgsql tableinfo return no table name

Details

Submitted2006-03-15 20:25 UTC
Fromfabrizio dot balliano at crealabs dot it
StatusWont fix
PackageDB
PHP VersionIrrelevant
Roadmaps(Not assigned)

Comments

[2006-03-15 20:25 UTC] fabrizio dot balliano at crealabs dot it

Description:
------------
---------------
$rs = $db->limitQuery($query,0,1);
$info = $db->tableInfo($rs);
---------------

$info is:
Array
(
[0] => Array
(
[table] =>
[name] => brand_id
[type] => int4
[len] => 4
[flags] =>
)

[1] => Array
(
[table] =>
[name] => description
[type] => text
[len] => -1
[flags] =>
)

[2] => Array
(
[table] =>
[name] => visible
[type] => bool
[len] => 1
[flags] =>
)

)

as you can see table name is empty but it's really important

Expected result:
----------------
Array
(
[0] => Array
(
[table] => tablename
[name] => brand_id
[type] => int4
[len] => 4
[flags] =>
)

[1] => Array
(
[table] => tablename
[name] => description
[type] => text
[len] => -1
[flags] =>
)

[2] => Array
(
[table] => tablename
[name] => visible
[type] => bool
[len] => 1
[flags] =>
)

)

[2006-03-15 20:42 UTC] fabrizio dot balliano at crealabs dot it

done
http://bugs.php.net/bug.php?id=36750

thank you

[2006-03-16 08:21 UTC] fabrizio dot balliano at crealabs dot it

here you have the answer:
The PostgreSQL API does not support this functionality.