Re: DB_DataObjects - PostgreSQL view error + ini
| From: | Fabio Fioravanti | Date: | Tue, 16 Nov 2004 22:54:31 +0000 |
| Subject: | Re: DB_DataObjects - PostgreSQL view error + ini | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-15578@lists.php.net to get a copy of this message | ||
> Hi!
>
> I tried to run createtables.php to create classes with:
> build_views = true
>
> And error is returned:
> db_dataobject_generator : CONNECT : NEW CONNECTION
> db_dataobject_generator : CONNECT :
> pgsql://user:pass@localhost/ostmart dac19c38c583a22259d25ae029c38d65
> [db_error: message="DB Error: insufficient data supplied" code=-20
mode=return
> level=notice prefix="" info="SELECT viewname FROM pg_views
[nativecode=ERROR:
> no existe la relaci?n "table_constraints"]"]sh-2.05b$
>
> I have instaled the last stable packages DB, DB_DataObjects and run on
> PostgreSQL 7.4.6 & php 4.3.9
I'm experiencing a similar problem: 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]"]
moreover I'm also experiencing problems with config options parsing:
although I've put
build_views = true
in my .ini config file, it does not get parsed:
indeed print_r says
[DB_DataObject] => Array
(
[database] => pgsql://postgres:postgres@localhost/koiffeur
[schema_location] => C:\\Program Files\\Apache Group\\Apache\\htdocs
\\koiffeur-pear
[links_koiffeur] => C:\\Program Files\\Apache Group\\Apache\\htdocs\
\koiffeur-pear\koiffeur_links.ini
[class_location] => C:\\Program Files\\Apache Group\\Apache\\htdocs\
\koiffeur-pear\DataObjects
[require_prefix] => DataObjects/
[class_prefix] =>
[build_views] => 0
[extends_location] =>
[extends] =>
[generator_class_rewrite] =>
[debug] => 0
[debug_ignore_updates] => 0
[dont_die] => 0
[dont_use_pear_sequences] => 0
)
Notice that I get this strange behavior
also with other config options (e.g. clientRules)!!!!
So I decided to comment out the following code in Generator.php
// build views as well if asked to.
//if (!empty($options['build_views'])) {
$this->tables = array_merge ($this->tables,
$__DB->getListOf('views'));
//}
but I get the errors reported above!!!
I'm using PHP Version 4.3.2 + Apache/1.3.24 + PostgreSQL 8.0.0 beta-dev1
on windows XP sp2 (bleah)
thanks in advance, Fabio