Re: Streaming binary data into db, difference between Blob

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