Re: Updatable views

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-patches(at)postgresql(dot)org
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Bernd Helmle <mailings(at)oopsware(dot)de>
Subject: Re: Updatable views
Date: 2008-05-08 12:56:57
Message-ID: 200805081456.58425.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2008-05-08 13:24:18 Re: Updatable views
Previous Message Simon Riggs 2008-05-08 12:28:14 Re: Updatable views

Browse pgsql-patches by date

  From Date Subject
Next Message Bernd Helmle 2008-05-08 13:24:18 Re: Updatable views
Previous Message Simon Riggs 2008-05-08 12:28:14 Re: Updatable views