Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] how to correctly invalidate a constraint? - Mailing list pgsql-hackers

From Pavel Stehule
Subject [HACKERS] how to correctly invalidate a constraint?
Date
Msg-id CAFj8pRC+UUtk_hE+0vSRveTfHsrE8mXTOAOdNZQ4QPxhLzL82A@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] how to correctly invalidate a constraint?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view
Hi

I would to do import without RI check - so I disable RI triggers. 

I would to invalidate constraint on Foreign Keys and then I would to use ALTER TABLE VALIDATE CONSTRAINT ...

I didn't find how to invalidate constraint without direct update pg_constraint.

Is there some clean way?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Unused member root in foreign_glob_cxt
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Fixing matching of boolean index columns to sort ordering