Roland Walter <rwa@mosaic-ag.com> writes:
> 時期 精霊 schrieb:
>> How can I trigger the deletion of the large object when the row
>> containing the oid is deleted?
>>
>> I mean I know that:
>> DELETE FROM pg_largeobject WHERE loid = nnn
>>
>> But is there in jdbc, an automatic way to handle that?
> There is a vacuumlo program in the contrib directory of the
> database source.
Also see contrib/lo for a trigger you can install to delete blobs
immediately when the reference is deleted.
regards, tom lane