Re: How to delete Large Object from Database?

From: "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th>
To: "Moises Alberto Lindo Gutarra" <mlindo(at)gmail(dot)com>, "Douglas McNaught" <doug(at)mcnaught(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to delete Large Object from Database?
Date: 2005-10-10 08:57:03
Message-ID: 434A8F53.C5F7.004C.0@nsasia.co.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

>>> Douglas McNaught <doug(at)mcnaught(dot)org> 07-Oct-05 20:13:36 pm >>>
Moises Alberto Lindo Gutarra <mlindo(at)gmail(dot)com> writes:

> try: delete from pg_catalog.pg_largeobject;
> from your database.

Umm, the standard way to do this is lo_unlink(). You can put an
ON DELETE trigger on your referencing table that calls this function.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Premsun Choltanwanich 2005-10-10 09:00:21 Re: How to delete Large Object from Database?
Previous Message Hannes Dorbath 2005-10-10 08:37:42 Re: INSERT OR UPDATE?