ODBC + BYTEA

From: Michael Knigge <Michael(dot)Knigge(at)SET-Software(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC + BYTEA
Date: 2009-07-06 17:28:11
Message-ID: 4A52342B.8090408@SET-Software.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

All,

I have some trouble getting a simple SQL working over an
ODBC-Connection. My Environment:

Client: MS-Windows XP, ODBC-Driver PSQLODBC35W.DLL, Version 08.02.0400
Server: MS-Windows XP, Version 8.2.4

My SQL:

CREATE TABLE "TestTable"
( "ColInt" INTEGER ,
"ColSmallint" SMALLINT ,
"ColVarchar" VARCHAR ( 50 ) ,
"ColTimestamp" TIMESTAMP ,
"ColChar" CHAR ( 1 ) ,
"ColDecimal" DECIMAL ( 8 , 2 ) ,
"ColBlob" BYTEA ) ;

Now.... when I execute this SQL via ODBC, I get a

<snip>
42704 (7:1260) ERROR: type "lo" does not exist;Error while executing the
query
</snip>

I've googled around a bit and if I got things right "lo" is somewhat an
old-style datatype for binary stuff and nowadays "bytea" should be used.

But why is the ODBC-Driver transforming it into "lo"? And when it is
still in use, why isn't the server recognizing it?

Please bring me in the right direction.....

Bye,
Michael

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Alex Goncharov 2009-07-06 18:02:06 Re: ODBC + BYTEA
Previous Message Lothar Behrens 2009-07-06 06:42:27 Re: SQLTables and szTableRemarks field?