[DOCS] NOTIFY man page still recommends rules

[Peter Eisentraut]

The NOTIFY man page writes

When <command>NOTIFY</command> is used to signal the occurrence of
changes
to a particular table, a useful programming technique is to put the
<command>NOTIFY</command> in a rule that is triggered by table updates.

Is using rules here still best practice? This was probably written
before statement triggers were available.

Even if yes, we might want to explain why, since we generally discourage
rule use otherwise.

[Alvaro Herrera]

Post by Peter Eisentraut
The NOTIFY man page writes
When <command>NOTIFY</command> is used to signal the occurrence of
changes
to a particular table, a useful programming technique is to put the
<command>NOTIFY</command> in a rule that is triggered by table updates.
Is using rules here still best practice? This was probably written
before statement triggers were available.
Even if yes, we might want to explain why, since we generally discourage
rule use otherwise.

I think it's easier to dodge the rules topic entirely here and just
mention statement triggers. Using rules you cannot cover the truncate
case, for instance.

[Tom Lane]

Post by Alvaro Herrera

Post by Peter Eisentraut
Is using rules here still best practice? This was probably written
before statement triggers were available.

I think it's easier to dodge the rules topic entirely here and just
mention statement triggers. Using rules you cannot cover the truncate
case, for instance.

+1

regards, tom lane

[Peter Eisentraut]

Post by Alvaro Herrera
I think it's easier to dodge the rules topic entirely here and just
mention statement triggers. Using rules you cannot cover the truncate
case, for instance.

done