Bug #2778

createtables.php fails building for postgres views

Details

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)

Comments

[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)

[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.