Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id DCA7A632FD6
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Dec 2009 16:23:18 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 64748-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Dec 2009 20:23:11 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id 5690963333B
	for <pgsql-sql@postgresql.org>; Wed, 16 Dec 2009 16:23:11 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id nBGKN9q6009410;
	Wed, 16 Dec 2009 15:23:09 -0500 (EST)
To: Britt Piehler <brittp@labkey.com>
cc: pgsql-sql@postgresql.org
Subject: Re: 8.3/8.4 SQL incompatibility? 
In-reply-to: <4B291979.9010601@labkey.com> 
References: <4B291979.9010601@labkey.com>
Comments: In-reply-to Britt Piehler <brittp@labkey.com>
	message dated "Wed, 16 Dec 2009 09:31:37 -0800"
Date: Wed, 16 Dec 2009 15:23:09 -0500
Message-ID: <9409.1260994989@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200912/44
X-Sequence-Number: 33482

Britt Piehler <brittp@labkey.com> writes:
> A generated query of ours broke on upgrade from PG 8.3.3 to 8.4.1 with 
> the following error:
> ERROR: failed to find conversion function from unknown to character varying

Hm.  I'm not going to promise that such cases should work always, but
given that this particular case worked before, it'd be nice if it kept
working.  I'll see what I can do about it.  It's too late for 8.4.2
though.

			regards, tom lane