Re: large objects and pg 7.3.x

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: andremachado(at)techforce(dot)com(dot)br, pgsql-odbc(at)postgresql(dot)org
Subject: Re: large objects and pg 7.3.x
Date: 2003-08-19 04:44:49
Message-ID: 3F41AB41.80E3C1EE@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Tom Lane wrote:
>
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> > Tom Lane wrote:
> >> The easy way to define "lo" now is just as a domain over oid:
> >> CREATE DOMAIN lo AS oid;
>
> > I'm suspicious if it still works even in 7.4.
> > Can we find the oid of the domain "lo" in the row description
> > message from the backend ?
>
> Hm, I think the column type will be reported as "oid", because the
> JDBC crowd argued that they didn't want to know about domains.
> Is that a problem for ODBC?

Probably no except the "lo" domain case.
Psqlodbc would be able to convert PG types to corresponding
ODBC types using known base types.

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-08-19 04:58:19 Re: ODBC Open cursors on views
Previous Message Tom Lane 2003-08-19 04:08:18 Re: large objects and pg 7.3.x