On 02/22/2017 07:32 AM, Jerry LeVan wrote:

On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:

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 ‘ ’.

The mail program is displaying the straight quote as a curly quote…
In the terminal program I see a straight quote.

I thought the issue was with the wxPython program not the terminal, or are you saying they are the same thing?

So you are see this(with straight quotes):

test=# select "'Boker'";
ERROR:  column "'Boker'" does not exist
LINE 1: select "'Boker'";

So why is the mail program not converting the double quotes to typographical quotes also? :

ERROR:  column "‘boker’" does not exist at character 41

or converting the single quotes I sent?



Perhaps wxpython is somehow confusing things… tain’t clear on
how to test.


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.kla...@aklaver.com




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to