Re: Conditional NOTIFY is not implemented

On Fri, 7 Sep 2001 tomas(at)fabula(dot)de wrote:

> On Fri, Sep 07, 2001 at 12:30:44AM -0400, Tom Lane wrote:
> > tomas(at)fabula(dot)de writes:
> > > My pattern of use for ``CREATE RULE... NOTIFY...'' was [...]
>
> > Yeah, that is the normal and recommended usage pattern for NOTIFY, so
> > getting a NOTIFY when nothing actually happened is fairly harmless.
> > (Undoubtedly that's why no one complained before.)
> >
> > Changing the rewriter to error out when it couldn't really Do The Right
> > Thing seemed like a good idea at the time, but now it seems clear that
> > this didn't do anything to enhance the usefulness of the system. Unless
> > someone objects, I'll change it back for 7.2.
> >
> > regards, tom lane
>
> I won't object ;-)
>
> Thank you again
> -- tomas

I wouldn't really mind that either. My employer wouldn't allow me to
change the current set of RULE/NOTIFY's to triggers so that we could
upgrade to 7.1.3 from 7.0.3, so having it act the same way in 7.2 as it
did in 7.0.3 would be nice for me. :)

Matthew M. Copeland