Re: [INTERFACES] BLOB handling compatibility with PostgreSQL > 7.4 - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: [INTERFACES] BLOB handling compatibility with PostgreSQL > 7.4
Date
Msg-id 20051206142811.GA23334@soptik.pzkagis.cz
Whole thread Raw
In response to Re: BLOB handling compatibility with PostgreSQL > 7.4  (Ludek Finstrle <luf@pzkagis.cz>)
Responses Re: [INTERFACES] BLOB handling compatibility with PostgreSQL > 7.4
List pgsql-odbc
Oh, I paste bad text and with combination of vi it gets into bad result.
I correct it now.

> We would like to upgrade the Postgres version from our current 7.3 but
> have problems with handling BLOBs via ODBC.
> We use unixODBC-2.2.11 and psqlodbc-08.01.0101.
> With postgres 7.3 lo type was mapped to SQL_C_BINARY and that's changed
> since postgres 7.4.
> Is it an ODBC or a driver issue? Are there any plans to fix the problem?

Hello,

  Irina reports problem with ODBC. I take deep look at it and find that
libpq returns base type oid instead of type oid. I'll describe it better.
We have this test suite:

CREATE DOMAIN lo as oid;
CREATE TABLE justlo(b lo);

insert one row:
INSERT INTO justlo VALUES (lo_import('file'));

we try get it throught libpq (maybe I miss some command):
SELECT b FROM justlo;
- PQsetNoticeProcessor(pgconn, CC_handle_notice, qres);
- pgres = PQexec(pgconn,query);
- PQsetNoticeProcessor(pgconn, CC_handle_notice, NULL);
...
- typid = PQftype(pgres,i);
    this returns typid = 26 (oid) instead of 25087 (lo)

postgres=# select oid from pg_type where typname='oid';
 oid
-----
  26
(1 row)
postgres=# select oid from pg_type where typname='lo';
  oid
-------
 25087
(1 row)

Is there any way to get 25087? It seems this behaviour is changed
between PgSQL 7.3 and 7.4. It looks like backend issue. Becouse it
returns different values with same binary for 7.3 and  >= 7.4
(all PgSQL >= 7.4 returns typid = 26 - directly tested 7.4, 8.1).

Thanks a lot for help

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: BLOB handling compatibility with PostgreSQL > 7.4
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] BLOB handling compatibility with PostgreSQL > 7.4