On Apr 26, 2005, at 11:20 AM, Tom Lane wrote:
The problem is that OLD is effectively a macro for the view, and once
you've deleted one of the rows, that ID is no longer present anywhere in
the view. Sometimes you can work around this by making the join an
outer join, but that's certainly a kluge.
Yah.
I don't think it's fixable without a fundamental rethinking of the feature.
Well, I'm not to worried about it for my current needs, but I can sure see how it would be unexpected and really bite someone.
So has anyone else done any rethinking of rules?
Cheers,
David
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
