Louis LeBlanc <db@keyslapper.org> writes:
>> For instance you need to explicitly delete a
>> large object when you don't need it any more --- deleting a table row
>> doesn't in itself make referenced large objects go away.
> This still sounds like our current model except for the fact that the
> OID has to be explicitly deleted. I assume a trigger could be set up
> to perform this on the fly though?
Yeah, as long as you keep things simple (no multiple references to
BLOBs) you can just add an ON DELETE trigger to handle that.
Given that this model is close to what you're already doing, large
objects probably are the way to go. Good luck with it.
regards, tom lane