On Tue, 2008-09-02 at 19:22 -0400, Tom Lane wrote: > Jeff Davis <pgsql@xxxxxxxxxxx> writes: > > My question is not why don't we allow subqueries in CHECK, my question > > is why do we allow stable/volatile functions? > > Historically we've allowed it, and it's not clear what we'd buy by > changing that, other than breaking existing applications whose authors > forgot to mark their functions immutable. If there were something we > could usefully do by checking the mutability status of the condition, > then it would be worth breaking compatibility here... > I suppose this means that we're already treating any CHECK constraint as immutable anyway, e.g. for constraint_exclusion? Regards, Jeff Davis
