Search Postgresql Archives

Re: Strange Errors...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux