Re: Checking FKs after COPY and disabled Triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Janning Vygen <vygen(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Checking FKs after COPY and disabled Triggers
Date: 2004-04-01 14:24:01
Message-ID: 28631.1080829441@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Janning Vygen <vygen(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Liu 2004-04-01 15:04:54 Re: select distinct w/order by
Previous Message Alvaro Herrera 2004-04-01 14:10:18 Re: 7.2.3-7.4.2 migration