Received: from maia.hub.org (maia-1.hub.org [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id C5987632B23
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 13 May 2010 12:14:24 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 12633-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 13 May 2010 15:14:17 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 867FA63224B
	for <pgsql-sql@postgresql.org>; Thu, 13 May 2010 12:14:17 -0300 (ADT)
Received: from in02.mta.xmission.com ([166.70.13.52])
	by out01.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1OCa74-0004lt-RX; Thu, 13 May 2010 09:14:14 -0600
Received: from [208.187.158.94] (helo=[172.16.1.220])
	by in02.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1OCa73-0004Df-MS; Thu, 13 May 2010 09:14:14 -0600
Message-ID: <4BEC182B.6010200@gmail.com>
Date: Thu, 13 May 2010 09:18:03 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.9) Gecko/20100317 SUSE/3.0.4-1.1.1 Thunderbird/3.0.4
MIME-Version: 1.0
To: gnanam@zoniac.com
CC: pgsql-sql@postgresql.org
References: <00da01caf04b$c182f900$4488eb00$@com>
	<016a01caf1be$be59d900$3b0d8b00$@com>
	<00ff01caf26a$8654f3d0$92fedb70$@com>
In-Reply-To: <00ff01caf26a$8654f3d0$92fedb70$@com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: gnanam@zoniac.com, pgsql-sql@postgresql.org,
	rsargent@amirsys.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa02 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;gnanam@zoniac.com
X-Spam-Relay-Country: 
Subject: Re: Invalid message format Exception
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: Yes (on in02.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.2 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201005/65
X-Sequence-Number: 34113



On 05/13/2010 01:04 AM, Gnanakumar wrote:
> Hi Rob,
> 
>> I'm sure most will urge you to move to UTF-8 encoding asap.
> Did you mean the database encoding to changed from SQL_ASCII to UTF-8?
> 
Yes.  That's pretty much the standard now.  I think it's Postgres'
default installation now (but don't quote me on that).

>> Have you tracked down the "offending" insert statement?  Perhaps it's a
>> trigger trying to generate a log message?
> No, I don't have any trigger on this table for INS/UPD/DEL.
> 
I think you'll need to track down example of inserts which are causing
the problem.