Ok, but in this particular case I don't see any caveats
You mean other than the infinite recursion, right?
and think that could be classic case for rule to be used.
If it is "almost never the correct solution" why rules still exists at all?
Backward compatibility, the "almost", and the fact that views use rules as an implementation mechanism.
David J.
View this message in context: Re: infinite recursion detected in rules for relation
Sent from the PostgreSQL - general mailing list archive at Nabble.com.