Re: creating CHECK constraints as NOT VALID

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: creating CHECK constraints as NOT VALID
Дата
Msg-id 4DF6987E.90201@agliodbs.com
обсуждение исходный текст
Ответ на creating CHECK constraints as NOT VALID  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Creating new remote branch in git?
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: creating CHECK constraints as NOT VALID