Davi Leal <davileal(at)terra(dot)es> writes:
> test=# DELETE FROM prod WHERE id=1;
> ERROR: Conditional NOTIFY is not implemented
7.2 allows this, as did 7.0 and before.
Conditional NOTIFY still isn't implemented, but you'll get an
unconditional notify instead (ie, NOTIFY whether or not any rows match
the DELETE's WHERE condition). This was the unintentional behavior of
older releases. It was "fixed" in 7.1, but people complained; the
not-quite-correct behavior is more useful than no behavior at all.
regards, tom lane