Re: Deleting BLOBs

On Sun, 12 Aug 2012, Tom Lane wrote:
> Neanderthelle Jones <elle@view.net.au> writes:
> > One attempt.  Is the error mine or PostgreSQL's?
>
> > $ for i in $(psql -q -t -U elle -d my_db \
> >  -c "SELECT raster FROM images where raster > 0"); do
> >  echo $i
> >  psql -q -U elle -d my_db -c "SELECT lo_unlink($i)"
> > done
>
> > 21234
> > ERROR:  large object 21234 does not exist
> > 21235
> > ERROR:  large object 21235 does not exist
> > [etc]
>
> That script looks reasonable enough, if perhaps not too fast.  Are you
> sure the table actually does reference live large objects?

Thanks, Tom.  No, because I fumbled a bit, and didn't vacuum.  They
may have gone, but I don't understand why the oids get echoed in that
case.

What does "live" mean?

Elle