Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes:
> Now I'm thinking I should make a patch for a demonstration of making a
> rule with >1 action though...
You're right, there are no such examples. It would be interesting to
make a full-fledged demonstration of maintaining a join view (where
delete from the join means delete from both tables) --- in particular
the need to use an outer join so that the first table delete doesn't
cause rows to disappear from the view.
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
