Jirí Pavlovský wrote:
>>> I'm getting these errors on tables as
>>> well. Actually when I copy and paste the offending queries from log into 
>>> pgAdmin it runs without an
>>> error.

>> So the queries work from pgadmin; what application/environment are they NOT 
>> working in?
>> Something is obviously different. You say it's a Win32 application, what 
>> database libraries and
>> programming languages are involved?

> I'm using  plain c and libpq from 9.2.2. And gtk as a GUI. Compiler is mingw 
> (gcc for windows).

>> Does the application perhaps send trailing garbage after the query or 
>> something similar?
>> Something like that might happen if there's a memory allocation bug in the 
>> application.
>> I'm assuming here that, if the query string cannot be converted from utf-8 
>> due to garbage
>> characters, the transcoding error triggers before the query parser notices a 
>> syntax error.

> Could be. But when I look at the query string in gdb, before it is send, I 
> don't see there anything
> problematic.
> I guess I'll have to try to wite some test cases to try to locate the problem.

Once you can reproduce the problem, try a network trace on the communication
between cleint and server.  Maybe that helps to solve the problem.

Yours,
Laurenz Albe

-- 
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