Re: db_dataobject createTables.php and postgresql

Culley Harrelson wrote:

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 I remember having that problems once. I think the problem was that I was logged in through the console (psql) and some other client. When I disconnected all the clients and then ran the createTables.php it worked just fine.

Maybe that helps. Jeroen