BUG #2267: Accessing large objects via ODBC
| От | Gerhard Lutz |
|---|---|
| Тема | BUG #2267: Accessing large objects via ODBC |
| Дата | |
| Msg-id | 20060216140652.2CD96F0B05@svr2.postgresql.org обсуждение исходный текст |
| Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2267 Logged by: Gerhard Lutz Email address: gerhard.lutz@mbtech-group.com PostgreSQL version: 8.1.3 Operating system: Windows XP SP2 Description: Accessing large objects via ODBC Details: 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?
В списке pgsql-bugs по дате отправления: