lo_unlink from a trigger

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: lo_unlink from a trigger
Date: 2002-07-16 17:50:44
Message-ID: ah1mdi$29ej$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using large objects, and storing the OID of the object in a table.
What I'd like to do is to clean up the object automatically when the
corresponding row is deleted, via a trigger or rule. Are there any hints
on how to do this? Can it only be done via an external language (such as
C), or is there a way to do this in native pl/psql?

--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-07-16 17:57:46 Re: size of function body
Previous Message Ralph Graulich 2002-07-16 17:43:43 size of function body