Re: Change in rule behavior? - Mailing list pgsql-hackers

From Sergio Pili
Subject Re: Change in rule behavior?
Date
Msg-id 3C021F3C.73A3DCB6@sinectis.com.ar
Whole thread Raw
In response to Change in rule behavior?  (Sergio Pili <sergiop@sinectis.com.ar>)
List pgsql-hackers
> What actually happened in your patched 7.1 was that the NOTIFY message
> was sent regardless of whether the WHERE condition was true or not.
> If you want that behavior, it's easy enough to get: put the NOTIFY in a
> separate rule that has no WHERE.


Oh!, you are all right of course.

In fact I not discovered this change with the Notify but with the
Deactivate Rule...
We proposed this command and you responded that you needed an example.
We send it and we don't receive answer. I take advantage to wonder for
that topic... 

Using the Deactivate Rule that we propose, doesn't care that the same
one is executed regardless of whether the WHERE condition was true or
not, but that would be already a detail of the new command and not
something general as me it proposed.

Thanks and regards

Sergio.


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: OCTET_LENGTH is wrong
Next
From: Teodor Sigaev
Date:
Subject: Pls, apply patch fot contrib/tsearch