No. It's because your view's WHERE clause is being added to your INSERT and of course nothing matches, so nothing gets inserted.
> That would fit with what I observe, but I’m not sure how I go about > proving EXPLAIN Thanks. You’re right - I should have thought to use EXPLAIN before posting here. Don't use RULEs. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr<http://2ndQuadrant.fr> PostgreSQL : Expertise, Formation et Support Repeating this, as if I should already know this, is less helpful though. It’s not as if the docs tells users to steer clear of RULEs. If there is something I don’t understand, such as RULEs, I prefer to experiment with it and ask questions if there is something I still don’t follow. I thought this was the correct forum for those questions.
