On 30th of June, Alvaro Herrera committed patch: Enable CHECK constraints to be declared NOT VALID This means that they can initially be added to a large existing table without checking its initial contents, but new tuples must comply to them; a separate pass ...

February 22nd, 2011 by depesz | Tags: , , , , , , , , | Comments Off on Waiting for 9.1 – INVALID FOREIGN KEYS

On 8th of February, Simon Riggs committed patch: Extend ALTER TABLE to allow Foreign Keys to be added without initial validation. FK constraints that are marked NOT VALID may later be VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and RowShareLock on referenced table. ...