"Mikael Carneholm" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
