Bhuvan A <bhuvansql@yahoo.com> writes:
> bhuvan=# CREATE RULE rule_test_rule AS ON insert TO rule_test do
> delete from rule_test where key = new.key;
You could probably make this work by doing it in a BEFORE INSERT
trigger, instead of a rule.
regards, tom lane