Postgres large object does not exist error for an existing object

Question

I am getting an error with Postgres 10 when trying to delete a large object ERROR: large object 16709 does not exist even though I can show 16709 does exist. I don't know if it is relevant, but the large object was created using pyscopg2 on Python 3.

EDIT: I confirmed that I can still fetch the data from the database, and that it is correct. I just can't delete it.

tagger1=# select l.oid from pg_largeobject_metadata l where l.oid = 16709;
  oid
-------
 16709
(1 row)

tagger1=# select count(1) from pg_largeobject where loid = 16709;
 count
-------
   747
(1 row)

tagger1=# select lo_unlink(16709) from pg_largeobject;
ERROR:  large object 16709 does not exist

Laurenz Albe · Accepted Answer · 2020-01-13 04:24:04Z

4

Simply omit the FROM clause:

SELECT lo_unlink(16709);

The problem is that your statement tries to run this for every row in pg_largeobject, but after the first execution the large object is already gone.

answered Jan 13, 2020 at 4:24

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chew socks Over a year ago

Thank you. Turns out in my program I was trying to unlink() twice using the pyscopg2 object, and then I made this mistake when debugging interactively.

Collectives™ on Stack Overflow

Postgres large object does not exist error for an existing object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related