Re: [GENERAL] Strange Errors... - Mailing list pgsql-general

> On Feb 22, 2017, at 9:20 AM, Adrian Klaver <adrian.klaver@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.

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