Re: DB_DataObjects - PostgreSQL view error + ini
| From: | Fabio Fioravanti | Date: | Wed, 17 Nov 2004 17:13:30 +0000 |
| Subject: | Re: DB_DataObjects - PostgreSQL view error + ini | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-15598@lists.php.net to get a copy of this message | ||
> Hi!
>
> After some test, the impresion is:
> DB class work fine, getListOf('views'); but....
> return a lot off pgsql internal views, internal
> views crach a DB_DataObject_Generator class,
> at this time my only solution is parse the array returned
> for predefined name prefix..... of views, bad solution!, but work...
replacing
return 'SELECT viewname FROM pg_views';
with
return 'SELECT viewname FROM pg_views WHERE schemaname=\'public\'';
in DB/pgsql.php
in the definition of getSpecialQuery
at line 823 does the dirty trick.
thank you all guys