Re: creating CHECK constraints as NOT VALID - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: creating CHECK constraints as NOT VALID
Date
Msg-id 4DF6987E.90201@agliodbs.com
Whole thread Raw
In response to creating CHECK constraints as NOT VALID  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
> I can see why you would want that, but I'd say that's a separate feature
> you need to explicitly request when creating the constraint.  Consider
> what happens in the "old data is garbage, but I want the new data to be
> validated" use case if we allow constraint exclusion on NOT VALID
> constraints.

Yeah, I guess what I'm suggesting is that we should have an ALTER TABLE
... VALID DONT CHECK option.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Creating new remote branch in git?
Next
From: Marko Tiikkaja
Date:
Subject: Re: creating CHECK constraints as NOT VALID