Re: lo_create(oid, bytea) breaks every extant release of libpq

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: lo_create(oid, bytea) breaks every extant release of libpq
Дата
Msg-id
CAFj8pRAQa2smRvZJkTabH5C7jQS_5A8nmxYSozPWOhbLvUcL6g@mail.gmail.com
Ответ на
Список
Дерево обсуждения
lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tatsuo Ishii <ishii@postgresql.org>
Re: lo_create(oid, bytea) breaks every extant release of libpq Pavel Stehule <pavel.stehule@gmail.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Noah Misch <noah@leadboat.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Andres Freund <andres@2ndquadrant.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Alvaro Herrera <alvherre@2ndquadrant.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Noah Misch <noah@leadboat.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Noah Misch <noah@leadboat.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Pavel Stehule <pavel.stehule@gmail.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Robert Haas <robertmhaas@gmail.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: lo_create(oid, bytea) breaks every extant release of libpq Pavel Stehule <pavel.stehule@gmail.com>
Re: lo_create(oid, bytea) breaks every extant release of libpq Pavel Stehule <pavel.stehule@gmail.com>



2014-06-12 6:22 GMT+02:00 Tatsuo Ishii <ishii@postgresql.org>:
> Meanwhile, we have to either revert the addition of lo_create(oid,
> bytea) altogether, or choose a different name for it.  Suggestions?

I wonder if there's any use case where we need to store bytea into
large objects. Don't we already have bytea data type? If the use case
is for large data which does not fit in a tuple, I am afraid that the
query string could become extremely big one.

I know a one use case - and I used it in my one application. For one my customer I wrote a application that ensures a data change between two independent subjects based on XML. It was relative simple architecture - applications solved a communication, and stored procedures solved a content - good success was a using of SQL/XML. After few years the communication protocol was enhanced about attached tiff scans - serialized in base64 in result XML doc. I had to quickly fix a this application with minimal impacts to others applications. And LO API is perfect for transporting binary data from/to database. But next I needed a functions for conversion between bytea and LO.

Regards

Pavel
 

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления
От: Noah Misch
Дата:
От: Tom Lane
Дата:
FAQ