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 по дате отправления: