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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general