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.
In response to
pgsql-interfaces by date
|Next:||From: Antonello De Santis||Date: 1999-03-27 14:43:23|
|Subject: Questions about pq library and ecpg|
|Previous:||From: Ryszard Lach||Date: 1999-03-26 22:31:41|