create rule radius1 as on update to user where (current.usrppp <> new.usrppp) do notify radius;
update user set usrname = 'Brett McCormick' where usrid = 'brett';
NOTIFY
the notification comes through on the radius relation (which, interestingly, doesn't exist)
linux 2.0.33, postgresql 6.3.2..
should I be filling out a bug report? ;)
or just using gdb
creating the table & dropping and recreating the rule has no effect