Dave Tenny wrote:
> You could always implement your own logical blob manager that implements
> blob IDs
> and breaks blobs into BYTEA records of a particular (manageable) maximum
> size and associates
> multiple BYTEA chunks with the blob id.
>
> More work, but a least common denominator approach that should be
> portable to other systems as well.
>
However, bytea is _not_ streamed on 7.3 backends (unless the patch is
used, which actually uses postgreSQL Large Objects as a staging area).
That would be fine for 7.4 where bytea values will be streamed though.
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9