lo_manage trigger on updates - Mailing list pgsql-docs

From Josh Kupershmidt
Subject lo_manage trigger on updates
Date
Msg-id CAK3UJRHaEuzfnZaxarcV8=RP1sC5xLxumzqx6iiyqpJVS89rjw@mail.gmail.com
Whole thread Raw
Responses Re: lo_manage trigger on updates
List pgsql-docs
Hi all,

I think the doc section about using lo_manage() as a trigger:
   http://www.postgresql.org/docs/current/static/lo.html

could have its example tweaked to use a column-level BEFORE UPDATE
trigger, so as to save unnecessary trigger firings. Something like the
attached, perhaps?

On a similar note, the warning on that page about truncates could be
softened if we extended the lo_manage() function to handle truncates,
and set it up as on ON TRUNCATE trigger as well.

Josh

Attachment

pgsql-docs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: DOCUMENTATION IN OTHERS IDIOMS
Next
From: Thom Brown
Date:
Subject: Foreign server version and type