Am 12.12.2009 16:56 schrieb Krishna Sandeep Reddy:
When I need to have capital letters in column names like 'info2D', then I have to give them in quotes while creating table. But when I use DB.get() to get a row, it fails to find the column in the table. I think the problem is in line: attnames = self.get_attnames(qcl)
You're right, mixed-case quoted identifiers are not handled properly by the classic pg module. The above line is not the real problem, but how the select clause in the query is built up from the attnames without putting them in quotes.
Most people use only lower or upper case names, and the test suite for the classic module does not check the mix-cased usage, so nobody ever noticed it. I have added a note to add tests and fix this in the next release. They should at least work in the internal queries.
Anyway, recommend not using mixed-case column or table names since they will call for trouble everywhere, not only here with PyGreSQL.
-- Christoph _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
