Re: Can't use subselect in check constraint - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Can't use subselect in check constraint
Date
Msg-id 200112202154.fBKLsq724811@candle.pha.pa.us
Whole thread Raw
In response to Re: Can't use subselect in check constraint  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
>
> On Wed, 19 Dec 2001, Tom Lane wrote:
>
> > "Ian Harding" <ianh@tpchd.org> writes:
> > > Is this something that will change anytime soon?
> >
> > It's not high-priority in my mind.  The difficulty is the lack of a
> > planning step for constraint expressions.  Maybe we could fix this
> > when we redesign querytrees; right now I think there's too much cruft
> > in the way (memory leaks, state kept in the querytree, etc etc)
>
> Also, AFAICS, check constraints with subselects are constraints on the
> other tables named in the subselect as well and it could be on a
> case which the current check constraints don't fire (for example
> on delete from a table where a set value function is used, like
> check (select count(*) from foo)>col1) or something like that).

It this a TODO item.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Can't use subselect in check constraint
Next
From: Larry Rosenman
Date:
Subject: Re: template question . . .