Issue Type: Bug Created: 2012-01-05T11:46:10.000+0000 Last Updated: 2012-04-10T14:09:32.000+0000 Status: Open Fix version(s): Reporter: Fabricio Valadares (fsvxavier) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db
Related issues: Attachments:
There was a problem with the list tables with connection with the adapter PDO PGSQL. When I have the same table name in different schemas list just a name not well differentiated by schema.
So I drew up a list SELECT where the tables in the schema PGSQL with differentiation. Below the query mentioned in the function to be tested listTables:
SELECT n.nspname the "schema" c.relname the "table_name" C.relkind CASE WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "typereg" u.usename the "proprietary" FROM pg_catalog.pg_class c INNER JOIN ON u.usesysid pg_catalog.pg_user u = c.relowner INNER JOIN ON n.oid pg_catalog.pg_namespace n = c.relnamespace C.relkind WHERE IN ('r','') And n.nspname NOT IN ('pg_catalog', 'pg_toast', 'information_schema') ORDER BY 1,2;
Posted by Adam Lundrigan (adamlundrigan) on 2012-02-26T06:36:07.000+0000
Could you please provide more information on what you are trying to accomplish?
Posted by Fabricio Valadares (fsvxavier) on 2012-04-10T14:09:32.000+0000
I'm generating the models and when I search for some tables in postgresql schema did not return the table schema if there is a table with the same name in another schema.
Have you found an issue?
See the Overview section for more details.