Catching dangling LOBs?

From: Vitaly Belman <vitalyb(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Catching dangling LOBs?
Date: 2005-04-14 22:51:16
Message-ID: fa96e3c60504141551208c5d98@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have quite a large database with lobs being referenced from a few
different table. While I made triggers/store procedures to unlink the
lob once the item is deleted, I am afraid there might be a glitch
somewhere in the code that leaving the LOBs dangling with no use
(except wasting the HD).

Is there a way for me to catch these unused LOBs?

--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-14 23:45:59 Re: Catching dangling LOBs?
Previous Message OpenMacNews 2005-04-14 20:26:41 pgsql config flag update: apple rendezvous renamed bonjour