ZF-11971: Zend DB - PDO conection PGSQL adapter list table error

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

  • Zend_Db_Table
  • adapter
  • db
  • pgsql
  • postgresql
  • schema
  • 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.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.