[EMAIL PROTECTED] writes: > Since PostgreSQL 7.1 (or 7.0, I don't remember), if you define a view, and >then a rule with a condition over the view, the rule doesn't work when you try to do >an operation from the type defined in the rule (it echoes an error message). But, if >you also define an empty rule of the same type on the same view with no condition, >the rule starts working. This is not a bug, it's intentional. Your suggestion of making the query rewrite limit a parameter seems like a good one. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly