Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC] - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
Date
Msg-id 36FC7757.4766FDF3@insightdist.com
Whole thread Raw
In response to [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]  (Byron Nikolaidis <byronn@insightdist.com>)
List pgsql-interfaces

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


pgsql-interfaces by date:

Previous
From: Ryszard Lach
Date:
Subject: subscribe
Next
From: Antonello De Santis
Date:
Subject: Questions about pq library and ecpg