Postgres Pro
Downloads
Home   >   mailing lists

Catching dangling LOBs? - Mailing list pgsql-general

From Vitaly Belman
Subject Catching dangling LOBs?
Date
Msg-id fa96e3c60504141551208c5d98@mail.gmail.com
Whole thread Raw
Responses Re: Catching dangling LOBs?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@hotmail.com
  Yahoo!: VitalyBe

pgsql-general by date:

Previous
From: OpenMacNews
Date:
Subject: pgsql config flag update: apple rendezvous renamed bonjour
Next
From: Tom Lane
Date:
Subject: Re: Catching dangling LOBs?