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

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 (view raw or flat)
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

pgsql-odbc by date

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

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