Re: Compatibility Issue of CREATE RULE in 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bhuvan A <bhuvansql(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Compatibility Issue of CREATE RULE in 7.2
Date: 2002-05-22 13:55:35
Message-ID: 23741.1022075735@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bhuvan A <bhuvansql(at)yahoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-05-22 13:56:49 Re: Bug with ORDER BY expression [ ASC | DESC ] ?
Previous Message Tille, Andreas 2002-05-22 13:25:13 Re: Turning column into row