| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.11.5 |
| Bug #2778 | createtables.php fails building for postgres views | ||
|---|---|---|---|
| Submitted: | 2004-11-17 09:46 UTC | ||
| From: | ff at ascoli dot biz | Assigned: | alan_k |
| Status: | Closed | Package: | DB_DataObject |
| PHP Version: | 4.3.2 | OS: | win xp |
| Roadmaps: | (Not assigned) | ||
[2004-11-17 09:46 UTC] ff at ascoli dot biz
Description:
------------
When I try to run createtables.php to create classes with:
build_views = true
I get the following error msg
[db_error: message="DB Error: insufficient data supplied" code=-20
mode=return level=notice prefix="" info="SELECT viewname FROM pg_views
[nativecode=ERROR: relation "view_column_usage" does not exist]"]
however select * from pg_views where viewname='view_column_usage'
does return a result
I'm using PHP Version 4.3.2 + Apache/1.3.24 + PostgreSQL 8.0.0 beta-dev1
on windows XP sp2 (bleah)
Comments
[2004-11-19 08:59 UTC] ff at ascoli dot biz
replacing
return 'SELECT viewname FROM pg_views';
with
return 'SELECT viewname FROM pg_views WHERE schemaname=\'public\'';
in DB/pgsql.php
in the definition of getSpecialQuery
at line 823 does the dirty trick.
[2004-11-20 02:49 UTC] alan_k
This bug has been fixed in CVS.
In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pear.php.net.
In case this was a pear.php.net website problem, the change will show
up on the website in short time.
Thank you for the report, and for helping us make PEAR better.