PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

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.