Thread: Re: Streaming binary data into db, difference between

Re: Streaming binary data into db, difference between

From
Andreas Prohaska
Date:
> > I assume that I can use this to read and write Blobs, not to delete them
> > since the LargeObject wouldn't be unlinked.
> >
>
> Neither to create.  But you can use the org.postgresql.largeobject
> extension both to create and to delete (unlink).
>

Why not? AbstractJdbc2Statement.setBlob(int, Blob) should create
new Blobs. Am I missing something?

I can delete unreferenced blobs easily with some kind of cron job.

Re: Streaming binary data into db, difference between

From
Fernando Nasser
Date:
Andreas Prohaska wrote:
>
> Why not? AbstractJdbc2Statement.setBlob(int, Blob) should create
> new Blobs. Am I missing something?
>

You are right, I thought that was not implemented...


> I can delete unreferenced blobs easily with some kind of cron job.
>



--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9