| 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: | Whole Thread | Raw Message | 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? |