Home » Database » DB_DataObject » Bug #3287

[2005-01-25 00:43 UTC] rolf at winmutt dot com

Description:
------------
This is a FreeBSD server, the DB is on a FreeBSD server as well. I even upgraded Postgres to 7.4.6, the same as what runs on the server the client and my home machine (Gentoo). My home machine executes this without issue.

I did this with build_views on and off.

I was able to runt he sql from the CLI w/o issue.

Reproduce code:
---------------
winmutt@winmutt$ php /usr/local/share/pear/DB/DataObject/createTables.php config.ini
DB_DataObject_Generator : 0 : CREATING FOR ilsi

[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)
AND c.relname !~ '^pg_'"]winmutt@winmutt$

Expected result:
----------------
to work

[2005-01-25 02:07 UTC] rolf at winmutt dot com

changing to DB:DO:FB, sry.
Cheers!

[2005-01-25 02:08 UTC] rolf at winmutt dot com

Both machines home and webserver are running php 5.0.3, is
this a FreeBSD issue?