Sorry I accidentally posted this to pgsql-general-owners earlier today…
********
How can this happen ( from the postgresql.log file)
LOG: statement: select * from knives where manufacturer=‘Boker’
ERROR: column "‘boker’" does not exist at character 41
Some background:
I am trying to move from 32 bit apps to 64 bit apps. I still
have a couple of 32 bit apps that talk to postgresql.
env:
MacOS Sierra 10.12.3
postgresql 9.6.2 compiled as a 64 bit program. I also
compiled it as a 32 bit program and glued the 64 bit
and 32 bit libpq libraries together and replaced the
installed 64 bit libpq library with the fat version.
python 2.7.10 Apple’s version
psycopg2 2.6.1
wxpython '3.0.3.0.b20160914’ installed from the wxpython.org site.
My main interaction with my database is a wxpython app. I type
sql into a text window and can send the contents of the window
or the selection or the line containing the cursor to postgresql
It appears that every single quote ( ‘ ) gets translated somehow to
a double quote ( “ ). SQL statements that do not use quotes return
properly and I can display the results in a grid.
I have modified one of the test programs in the psycopg2 distribution
that sends the selection shown in the log statement and it works
properly. i.e. I can send the select statement and retrieve the results
from a the psycopg2 python program.
I can run basically the same wxpthon program on my fedora system without
any problems (talking to the mac ).
Any suggestions would be appreciated.
Jerry
