"michael crozier" <[EMAIL PROTECTED]> writes: > Using a function invocation in the WHERE expression of a RULE causes the > backend to crash.
It's not the function, it's the whole-row Var (ie, unqualified "NEW") that doesn't work. Whole-row Vars in rules never worked at all before 8.0, and evidently they don't work in all contexts in 8.0 either :-(. It's unlikely we'll try to make this actually work in 8.0, but I'll look into erroring out cleanly instead of crashing. Unfortunately it's too late for 8.0.8 :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq