On Jan 24, 2016, at 8:17 PM, Christophe Pettus <[email protected]> wrote: > 2. Use the NOT VALID option on ALTER TABLE ... ADD constraint, which allows > the addition of a constraint without actually checking its validity.
And note that you might miss some potential planner optimizations this way, as the planner will not assume the constraint holds true unless you remove the NOT VALID condition from it with VALIDATE CONSTRAINT. -- -- Christophe Pettus [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
