Skip site navigation (1) Skip section navigation (2)

PEAR DB_DataObjects - PostgreSQL view error

From: "Fabio Fioravanti" <ff(at)ascoli(dot)biz>
To: pgsql-php(at)postgresql(dot)org
Subject: PEAR DB_DataObjects - PostgreSQL view error
Date: 2004-11-17 09:48:47
Message-ID: 1971.195.223.183.238.1100684927.squirrel@195.223.183.238 (view raw or flat)
Thread:
Lists: pgsql-php
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)

Any hints?

pgsql-php by date

Next:From: Adam WitneyDate: 2004-11-26 15:10:16
Subject: Inserting greek letters
Previous:From: Joshua D. DrakeDate: 2004-11-17 07:14:49
Subject: Re: plPHP on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group