Re: lo_manage trigger on updates - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: lo_manage trigger on updates
Date
Msg-id 20120815032220.GC25473@momjian.us
Whole thread Raw
In response to Re: lo_manage trigger on updates  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-docs
On Mon, Oct 10, 2011 at 01:18:56PM -0400, Robert Haas wrote:
> On Thu, Aug 11, 2011 at 11:43 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> > 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?
>
> Uh, wow.  That syntax is horribly surprising, isn't it?  My eyes want
> to parse it as:
>
> BEFORE (UPDATE OF raster) OR (DELETE ON image)
>
> ...which is totally wrong.
>
> I'm inclined to think that maybe we should leave that example as-is,
> and maybe add the variant you're proposing as a second example,
> showing how the basic version can be refined.

I have implemented this suggestion with the attached, applied patch to
9.3.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Attachment

pgsql-docs by date:

Previous
From: Chris Travers
Date:
Subject: Re: Would like to contribute a section to docs for 9.3. Where to start?
Next
From: Bruce Momjian
Date:
Subject: Re: lo_manage trigger on updates