"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
pgsql-bugs by date
|Next:||From: li fei||Date: 2005-11-07 07:40:07|
|Subject: BUG #2022: template0 Fefresh error|
|Previous:||From: Tom Lane||Date: 2005-11-05 22:51:38|
|Subject: Re: create OR REPLACE rule bug |