| 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) | ||
[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..