Re: Checking FKs after COPY and disabled Triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: Checking FKs after COPY and disabled Triggers
Date
Msg-id 28631.1080829441@sss.pgh.pa.us
Whole thread Raw
In response to Checking FKs after COPY and disabled Triggers  (Janning Vygen <vygen@gmx.de>)
Responses Re: Checking FKs after COPY and disabled Triggers
List pgsql-general
Janning Vygen <vygen@gmx.de> writes:
> can i check my database for violating FKs if i populated the database with FK
> constraints disabled?

Drop the constraints and then add them back afterwards.  You might want
to think about dropping and rebuilding indexes as well.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 7.2.3-7.4.2 migration
Next
From: Tom Lane
Date:
Subject: Re: Large DB