Bug report 2267: Accessing large objects via ODBC
| От | Gerhard.Lutz@mbtech-group.com |
|---|---|
| Тема | Bug report 2267: Accessing large objects via ODBC |
| Дата | |
| Msg-id | OFE25744AB.6F5D8294-ONC1257122.0046B4DE-C1257122.004713FA@dcx.dcx обсуждение исходный текст |
| Ответы |
Re: Bug report 2267: Accessing large objects via ODBC
|
| Список | pgsql-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: PostgreSQL Unicode).
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);
::SQLFetch(m_hStmt);
::SQLGetData(m_hStmt, nCol, SQL_C_BINARY, pBuffer, nPacketSize, &sdODataLength);
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?
Best regards
Gerhard Lutz
Test Solutions
MB-technology GmbH
Fon +49-160/8609695
Fax +49-711-3052120743
mailto:gerhard.lutz@mbtech-group.com
Mailing address: HPC G170 / D-71059 Sindelfingen
Visitors address: Kolumbusstrasse 2 / D-71063 Sindelfingen
Notice:
This email may contain confidential information. If you are not the addressee you are not authorized to make use of the information contained in this email.
Please inform us immediately that you have received it by mistake.
В списке pgsql-odbc по дате отправления: