Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group