Re: create OR REPLACE rule bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: create OR REPLACE rule bug
Date: 2005-11-05 23:02:06
Message-ID: 20815.1131231726@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> writes:
> However, the rule does not work as expected (but I have been warned, see http://archives.postgresql.org/pgsql-general/2005-10/msg01902.php)

Once you do the DELETE, there is no OLD row anymore, so there is nothing
for the INSERT to do.

You might have better luck implementing this stuff as triggers.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message li fei 2005-11-07 07:40:07 BUG #2022: template0 Fefresh error
Previous Message Tom Lane 2005-11-05 22:51:38 Re: create OR REPLACE rule bug