Natrually right after I sent this post I found the problem. The String was
'uAKcXMobT3^(at)AAAAAAAAA
... which is the old problem with jdbc and embedded 0 charachters. In
what version of the driver was that fixed?
Joseph Shraibman wrote:
> I'm having a wierd problem with pg 7.3.3
>
> PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
> 20020903 (Red Hat Linux 8.0 3.2-7)
>
> I have a bunch of inserts being done by JDBC. One of them if causing a
> problem.
>
> LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate)
> VALUES(99999933,'Sent via localhost','2003-08-27 11:07:53.701');
> LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate)
> VALUES(99999934,'While talking to mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3
> ERROR: parser: unterminated quoted string at or near "'While talking to
> mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3" at character 59
> FATAL: Socket command type A unknown
>
>
> Obviously the pg log is not showing the end of the instert I'm sending
> via jdbc. I'm not sure what the string is supposed to be because it is
> dynamically generated, but it should have been something like the line
> above it.
>