db_dataobject createTables.php and postgresql
| From: | Culley Harrelson | Date: | Wed, 11 Aug 2004 20:27:12 +0000 |
| Subject: | db_dataobject createTables.php and postgresql | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-14067@lists.php.net to get a copy of this message | ||
I was trying to run createTables.php on my database and got:
[db_error: message="DB Error: insufficient data supplied" code=-20
mode=return level=notice prefix="" info="SELECT c.relname as "Name"
FROM pg_class c, pg_user u
WHERE c.relowner = u.usesysid AND c.relkind = 'r'
AND not exists (select 1 from pg_views where
viewname = c.relname)
AND c.relname !~ '^(pg_|sql_)'
UNION
SELECT c.relname as "Name"
FROM pg_class c
WHERE c.relkind = 'r'
AND not exists (select 1 from pg_views where
viewname = c.relname)
AND not exists (select 1 from pg_user where
usesysid = c.relowner)
I can run this sql manually and it works. I granted select on
pg_class and pg_users to the user indicated in the ini file and it
still doesn't work (when I log in to psql as the user I can run the
sql). Any tips?
I am using postgresql 7.4.1 and
DB 1.6.5
DB_DataObject 1.7.1
culley