Re: Subqueries in Check() -- Still Intentionally Omitted? - Mailing list pgsql-general

From Richard Broersma
Subject Re: Subqueries in Check() -- Still Intentionally Omitted?
Date
Msg-id 396486430809021707x45d34935lab11fc8722f42a23@mail.gmail.com
Whole thread Raw
In response to Re: Subqueries in Check() -- Still Intentionally Omitted?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Tue, Sep 2, 2008 at 3:47 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

> The problem is that you have to rerun the query to verify that the CHECK
> condition still holds, whenever the table that the CHECK clause is
> checking changes.  This is rather problematic, because we'd need to make
> the system aware of such reverse dependencies.

Thanks for the clarification.  This makes sense.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: Matthew Wilson
Date:
Subject: Re: Foreign Key normalization question
Next
From: Tom Lane
Date:
Subject: Re: Subqueries in Check() -- Still Intentionally Omitted?