Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.2/8.9.1) with ESMTP id BAA21132
	for <pgsql-interfaces@postgreSQL.org>;
	Sat, 27 Mar 1999 01:34:56 -0500 (EST)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id BAA09161
	for pgsql-interfaces@postgreSQL.org;
	Sat, 27 Mar 1999 01:21:15 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA31252; Sat, 27 Mar 1999 01:07:23 -0500
Received: from ppp0_ceodev by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA40012; Sat, 27 Mar 1999 01:07:21 -0500
Message-Id: <36FC7757.4766FDF3@insightdist.com>
Date: Sat, 27 Mar 1999 01:14:47 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Sam@OConnor.net
Cc: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
References: <36F902CC.3FE1EF8B@insightdist.com>
	<36FB5F99.FCE445D6@netspace.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Sam O'Connor wrote:

> Problem solved!
>
> I modified the ODBC driver to put single quotes around the oid in the
> SQL query.
> Now it works.
>
> I can send you a diff if you like.
>
> I figured this out by trying (in psql):
> INSERT INTO image VALUES (1,1,'test',123); // causes an error
> INSERT INTO image VALUES (1,1,'test','123'); // this works
>

Ahhhh,  I see now.   On Postgres 6.3 it works with or without the quotes.  But, on Postgres 6.4, it must be quoted!

I wonder if this was an intentional change, or a bug or what?

I will try to post a patch for the quotes.

Byron