Dangling large objects

Поиск
Список
Период
Сортировка
От Adam Haberlach
Тема Dangling large objects
Дата
Msg-id 20010108135758.A20131@newsnipple.com
обсуждение исходный текст
Ответы Re: Dangling large objects
Re: Dangling large objects
Список 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@newsnipple.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "elein"
Дата:
Сообщение: hex input values
Следующее
От: Justin Banks
Дата:
Сообщение: RE: replication followup