PostgreSQL : NOT VALID constraint vs validation trigger
I have a table with a "currency" column. I'd like to prevent further insertion of certain currencies, without removing the existing ones. Initially I was thinking of a validation trigger. Then I discovered the NOT VALID option of ALTER TABLE ADD CONSTRAINT , which prevents the validation of existing data. The documentation seems to imply that the NOT VALID o