Re: Updatable views - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: Updatable views
Date
Msg-id 200805081456.58425.peter_e@gmx.net
Whole thread Raw
In response to Re: Updatable views  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Updatable views
List pgsql-patches
Am Donnerstag, 8. Mai 2008 schrieb Simon Riggs:
>  CREATE RULE somename AS ON INSERT TO x WHERE where-clause DO INSERT ...
>
> which seems straightforward, no?

Double evaluation is the key word.  The conclusion was more or less that you
can't implement check constraints using the rules system.  You need to check
them in the executor.

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Updatable views
Next
From: Bernd Helmle
Date:
Subject: Re: Updatable views