Neanderthelle Jones <elle@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
