From: | Adam Haberlach <adam(at)newsnipple(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Dangling large objects |
Date: | 2001-01-08 21:57:58 |
Message-ID: | 20010108135758.A20131@newsnipple.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm in a bit of a bind here. I wrote some code in our abstraction
layer to automatically unlink large objects when the row referencing
them is deleted (I know that they are only referenced once). However,
I neglected to include them in a transaction, so I'm pretty sure that
those unlinks never happened.
Is there any simple way for me to get a list of all large objects
in a database, so I can see if there are actually rows referring to them
and delete the ones that were not unlinked earlier?
--
Adam Haberlach |A cat spends her life conflicted between a
adam(at)newsnipple(dot)com |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Banks | 2001-01-08 22:29:50 | RE: replication followup |
Previous Message | elein | 2001-01-08 21:34:30 | hex input values |