| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Roland Walter <rwa(at)mosaic-ag(dot)com> |
| Cc: | 時期 精霊 <kuon(at)goyman(dot)com>, Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Streaming blob to db |
| Date: | 2005-07-05 14:31:46 |
| Message-ID: | 12922.1120573906@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Roland Walter <rwa(at)mosaic-ag(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-07-05 23:05:15 | Re: JDBCCTS issues |
| Previous Message | Roland Walter | 2005-07-05 13:54:35 | Re: Streaming blob to db |