Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5

Request #11081 Support for createTables on Postgres with views in schema
Submitted: 2007-05-19 09:28 UTC
From: senna Assigned:
Status: Verified Package: DB_DataObject
PHP Version: Irrelevant OS:
Roadmaps: (Not assigned)    
Subscription  


 [2007-05-19 09:28 UTC] senna (Koichi Tanaka)
Description: ------------ now, you cannot run createTables.php with PostgreSQL when you have defined any views in schema such as 'test_schema.test_view'. so, I rewrote (Generate.php line220): // try getting a list of schema views first. (postgres) $views = $__DB->getListOf('schema.views'); if (empty($views)|| is_a($views, 'PEAR_Error')) { $views = $__DB->getListOf('views'); } Of cause, this does not work because PEAR_DB don't support 'schema.views'. Now, I post a request to suport this.(Bug #11080: getListOf('schema.views')) If my request is accepted in PEAR_DB, please accept this request :-)

Comments

 [2007-06-29 13:18 UTC] aharvey (Adam Harvey)
This has been implemented as of DB 1.7.12, per request #11080.
 [2008-02-27 06:12 UTC] alan_k (Alan Knowles)
need to check db version but otherwise patch is probably ready to go in..