On Thu, 2008-05-08 at 17:20 +0200, Bernd Helmle wrote: > --On Donnerstag, Mai 08, 2008 14:42:50 +0100 Simon Riggs > <[EMAIL PROTECTED]> wrote: > > > That makes sense. I can't see how we would make LOCAL CHECK CONSTRAINTs > > work with rules anyhow. > > One of the idea's that came up through the discussion was to make the > rewriter responsible for collecting check constraints such as the local > check condition. They would be pushed down to the executor then where the > correct constraints would be applied. However, i'm currently not in the > position to say if this is doable right now.
That's what I was thinking too. > The original updatable views patch tracked the state of required and > applied rule conditions during rewrite. This way it applied only the rule > conditions of the specified view in cascading updates. Yes, seems like the only way we'll get LOCAL CHECK CONSTRAINTS to work. Are you planning to work on this? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches