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?
regards, tom lane