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