Re: How to delete Large Object from Database? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: How to delete Large Object from Database?
Date
Msg-id 434A3D2F.90907@archonet.com
Whole thread Raw
In response to Re: How to delete Large Object from Database?  ("Premsun Choltanwanich" <Premsun@nsasia.co.th>)
Responses Re: How to delete Large Object from Database?
List pgsql-sql
Premsun Choltanwanich wrote:
> 
> The lib I use is call lo_in and lo_out for manage BLOB.
>  
> I understand that lo_unlink be related with lo_import and lo_export so I 
> don't think that it work.

If you are using the contrib/lo library, then README.lo mentions:

* Some frontends may create their own tables, and will not create the  associated trigger(s). Also, users may not
remember(or know) to 
 
create the triggers.

Could this be the case with your database? There are a couple of other 
points in the README.lo that are worth checking too.

--  Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: "Premsun Choltanwanich"
Date:
Subject: Re: How to delete Large Object from Database?
Next
From: "Premsun Choltanwanich"
Date:
Subject: Re: How to delete Large Object from Database?