Re: large objects and pg 7.3.x

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: large objects and pg 7.3.x
Дата
Msg-id 3F41A171.5486A3FC@tpf.co.jp
обсуждение исходный текст
Ответ на large objects and pg 7.3.x  (Andre Felipe Machado <andremachado@techforce.com.br>)
Ответы Re: large objects and pg 7.3.x  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: large objects and pg 7.3.x
Следующее
От: Tom Lane
Дата:
Сообщение: Re: large objects and pg 7.3.x