Re: create OR REPLACE rule bug

"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.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