| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.2 |
| Request #11080 | getListOf('schema.views') | ||
|---|---|---|---|
| Submitted: | 2007-05-19 08:54 UTC | ||
| From: | senna | Assigned: | aharvey |
| Status: | Closed | Package: | DB |
| PHP Version: | Irrelevant | OS: | |
| Roadmaps: | 1.7.12 | ||
[2007-05-19 08:54 UTC] senna
(Koichi Tanaka)
Description:
------------
add support in the postgres driver for fetching a list of views with
their schema prefix.(like Request #682)
addition to pgsql.php / getSpecialQuery()
case 'schema.views':
return "SELECT schemaname || '.' || viewname from pg_views WHERE schemaname"
. " NOT IN ('information_schema', 'pg_catalog')";
Comments
[2007-06-29 13:10 UTC] aharvey
(Adam Harvey)
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.