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,I wonder if there's any use case where we need to store bytea into
> bytea) altogether, or choose a different name for it. Suggestions?
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
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
Дата: