views:

116

answers:

1

should I call lo_unlink ? A delete didn't remove the object from pg_largeobject.

+2  A: 

Yes, you need to explicitly call lo_unlink(). I assume you just DELETEd the row that held a reference to it, and that will not remove the actual large object.

If you only ever reference it from the same place, you can always create a trigger to do it automatically for you.

Magnus Hagander
tks for your answer. I made the trigger and works great :D
Dani Cricco