Re: creating CHECK constraints as NOT VALID

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: creating CHECK constraints as NOT VALID
Date: 2011-06-13 23:08:46
Message-ID: 4DF6987E.90201@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-06-13 23:47:31 Re: pg_trgm: unicode string not working
Previous Message Marko Tiikkaja 2011-06-13 23:00:34 Re: creating CHECK constraints as NOT VALID