Skip site navigation (1) Skip section navigation (2)

Re: Bug report 2267: Accessing large objects via ODBC

From: Gerhard(dot)Lutz(at)mbtech-group(dot)com
To: luf(at)pzkagis(dot)cz
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-odbc-owner(at)postgresql(dot)org
Subject: Re: Bug report 2267: Accessing large objects via ODBC
Date: 2006-02-28 14:52:10
Message-ID: OF458F3461.9CD9B4ED-ONC1257123.00509389-C1257123.0051AE57@dcx.dcx (view raw or flat)
Thread:
Lists: pgsql-odbc
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 
Objects (lo)"
while installing PostgreSQL. This worked with PostgreSQL 8.0.4.

I didn't find a special psqlODBC FAQ, only the general FAQ lists at 
www.postgresql.org.

Best regards,
Gerhard Lutz




luf(at)pzkagis(dot)cz 
Gesendet von: pgsql-odbc-owner(at)postgresql(dot)org
27.02.2006 14:24

An
Gerhard(dot)Lutz(at)mbtech-group(dot)com
Kopie
pgsql-odbc(at)postgresql(dot)org
Thema
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: 
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?

I see no psqlODBC version in your report.
How did you create the lo type? Did you follow psqlODBC FAQ?

Regards,

Luf

---------------------------(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 WeaverDate: 2006-02-28 19:29:52
Subject: Re: psqlODBC Experimental Enhanced branch
Previous:From: Ludek FinstrleDate: 2006-02-27 13:24:31
Subject: Re: Bug report 2267: Accessing large objects via ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group