Re: A Couple of Questions on Blobs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Holmes <sholmes(at)pacificnet(dot)net>
Cc: pgsql-general(at)postgresql(dot)org (PG-General)
Subject: Re: A Couple of Questions on Blobs
Date: 2001-05-23 15:45:48
Message-ID: 14821.990632748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Holmes <sholmes(at)pacificnet(dot)net> writes:
> First, I believe I probably have some orphan blobs in one of my
> databases. I have updated some records, replacing one image oid with
> another before I knew about lo_unlink. Is there a method for finding
> such stranded objects?

I think contrib/vacuumlo will help.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2001-05-23 15:51:16 Re: Incrementing a date type.
Previous Message snpe 2001-05-23 15:33:58 Re: Simple question for SQL Student