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

Doc Bug #12025 Generator does not generate keys with quote_identifiers = 1
Submitted: 2007-09-11 13:50 UTC
From: ernst Assigned:
Status: No Feedback Package: DB_DataObject (version 1.8.7)
PHP Version: 5.2.1 OS: win xp
Roadmaps: (Not assigned)    
Subscription  


 [2007-09-11 13:50 UTC] ernst (Ernst Hansmair)
Description: ------------ The Generater.php of DB_DataObject with DB_pgsql driver can not generate key descriptions for the keys when the configuration variable quote_identifiers is true. The tablenames are generated with quotation marks. Table customer results in a quoted tablename of "customer". In DB\pgsql.php this is quoted again resulting in a statement like select f.attnotnull, f.atthasdef from pg_attribute f, pg_class tab, pg_type typ where tab.relname = typ.typname and typ.typrelid = f.attrelid and f.attname = '_id' and tab.relname = '"customer"' This statement results in an error, which is not catched. KKey descriptions are not generated. Expected result: ---------------- Please add to the description of the option "quote_identifiers" that for Postgres this must be 0/false.

Comments

 [2008-03-31 15:26 UTC] saltybeagle (Brett Bieber)
I get the feeling this is an actual bug, and not a documentation issue. I'd like to get some more feedback on this before making any changes to the quote_identifiers documentation.
 [2008-04-29 02:53 UTC] alan_k (Alan Knowles)
I think this is fixed in CVS new option: quote_identifiers_tableinfo = 1 (defaults to off)