Skip site navigation (1) Skip section navigation (2)

Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: Sam(at)OConnor(dot)net
Cc: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
Date: 1999-03-27 06:14:47
Message-ID: 36FC7757.4766FDF3@insightdist.com (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-interfaces by date

Next:From: Antonello De SantisDate: 1999-03-27 14:43:23
Subject: Questions about pq library and ecpg
Previous:From: Ryszard LachDate: 1999-03-26 22:31:41
Subject: subscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group