On 02/22/2017 07:09 AM, Jerry LeVan wrote:
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
No: test=# select ‘Boker’; ERROR: column "‘boker’" does not exist LINE 1: select ‘Boker’; test=# select 'Boker'; ?column? ---------- Boker (1 row) It is because they are ‘ ’ not ' '. So you need to find out what is causing your program to introduce ‘ ’.
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
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
