Hi,
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)
Here the attibute names doesn't have quotes and the they are directly
used to form a query which results in error.
Sample debug session: (pg.py line 515)
>>> q
'SELECT camID, frameKey, time, frameID FROM public."S_MobFrame" WHERE
frameKey = 34 LIMIT 1'
>>> self.get_attnames(qcl)
{'camID': 'text', 'frameKey': 'int', 'time': 'date', 'frameID': 'int'}
>>> self.db.query(q).dictresult()
Traceback (most recent call last):
File "<string>", line 1, in <fragment>
pg.ProgrammingError: ERROR: column "camid" does not exist
LINE 1: SELECT camID, frameKey, time, frameID FROM public."S_MobFram...
^
Let me know if I am wrong.
Cheers.
dksr
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
