how to correctly invalidate a constraint?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: how to correctly invalidate a constraint?
Date: 2017-01-13 13:21:02
Message-ID: CAFj8pRC+UUtk_hE+0vSRveTfHsrE8mXTOAOdNZQ4QPxhLzL82A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-01-13 13:29:43 Re: Fixing matching of boolean index columns to sort ordering
Previous Message Tom Lane 2017-01-13 13:16:21 Re: Unused member root in foreign_glob_cxt