The version of PSQLODBC.DLL is 8.01.02.00.
In version 8.00.01.03 I didn't have this problem.
I didn't create the lo type explicitly. I just checked the checkbox "Large
while installing PostgreSQL. This worked with PostgreSQL 8.0.4.
I didn't find a special psqlODBC FAQ, only the general FAQ lists at
Gesendet von: pgsql-odbc-owner(at)postgresql(dot)org
Re: [ODBC] Bug report 2267: Accessing large objects via ODBC
> I want to upgrade my PostgreSQL server from 8.0.4 to 8.1.3.
> My C++ application connects to the database via ODBC (ODBC driver:
> I've installed 8.1.3 with "large objects (lo)" and created a table
> CREATE testdata
> (id integer not null,
> buffer lo);
> So far this worked.
> Now if I want to get the 'buffer' column
> ::SQLExecDirect(m_hStmt, (unsigned char*)"SELECT buffer FROM testdata
WHERE id=6", SQL_NTS);
> ::SQLGetData(m_hStmt, nCol, SQL_C_BINARY, pBuffer, nPacketSize,
> I get the error message
> "Received an unsupported type from Postgres. (14)"
> In PostgreSQL 8.0.4 this worked without a problem.
> In 8.1.3 I can also see in pgAdmin III that there are no functions
> lo_in(lo) and lo_out(lo) in the tree.
> Perhaps this is an installation bug in 8.1.3?
> Has anybody got an idea?
I see no psqlODBC version in your report.
How did you create the lo type? Did you follow psqlODBC FAQ?
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
In response to
pgsql-odbc by date
|Next:||From: George Weaver||Date: 2006-02-28 19:29:52|
|Subject: Re: psqlODBC Experimental Enhanced branch|
|Previous:||From: Ludek Finstrle||Date: 2006-02-27 13:24:31|
|Subject: Re: Bug report 2267: Accessing large objects via ODBC|