Re: Deleting BLOBs

On Sun, 12 Aug 2012, Tom Lane wrote:
> Neanderthelle Jones <elle(at)view(dot)net(dot)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