Re: Updatable views - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Updatable views
Date
Msg-id 1210260879.4268.390.camel@ebony.site
Whole thread Raw
In response to Re: Updatable views  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Updatable views  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-patches
On Thu, 2008-05-08 at 17:20 +0200, Bernd Helmle wrote:
> --On Donnerstag, Mai 08, 2008 14:42:50 +0100 Simon Riggs
> <simon@2ndquadrant.com> 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


pgsql-patches by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Updatable views
Next
From: Bruce Momjian
Date:
Subject: Re: libpq thread-locking