On Sun, 12 Aug 2012, Tom Lane wrote: > Neanderthelle Jones <e...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
