From: Byron Nikolaidis <byronn@insightdist.com>
To: Sam@OConnor.net
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
Date: Sat, 27 Mar 1999 01:14:47 -0500
Message-ID: <36FC7757.4766FDF3@insightdist.com> (raw)
References: <36F902CC.3FE1EF8B@insightdist.com>
<36FB5F99.FCE445D6@netspace.net.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, Sam@OConnor.net
Subject: Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
In-Reply-To: <36FC7757.4766FDF3@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox