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
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? |