Re: large objects and pg 7.3.x - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: large objects and pg 7.3.x
Date
Msg-id 3F41A171.5486A3FC@tpf.co.jp
Whole thread Raw
In response to large objects and pg 7.3.x  (Andre Felipe Machado <andremachado@techforce.com.br>)
Responses Re: large objects and pg 7.3.x  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Tom Lane wrote:
>
> Andre Felipe Machado <andremachado@techforce.com.br> writes:
> > Since pg 7.3.0, the prescribed workaround to create a new type "lo" does not
> > work anymore.
>
> I think this is just a matter of obsolete documentation ---

Maybe pointing to contrib/lo is preferable. However, few people
take care of contrib/lo and it seems easily broken.
PostgreSQL has never supported LO properly and I can't recommend
anything for continuous LO use.

> if you can
> point to where it still says to use a CREATE TYPE hack, we can fix it.
> 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 ?

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

pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: large objects and pg 7.3.x
Next
From: Tom Lane
Date:
Subject: Re: large objects and pg 7.3.x