Re: How to add constraints without validating data.

Constraints are special triggers, but triggers anyway.

So, If you truncate the table, create the contraint and then restore
with triggers disabled, it could be faster that create the contraint and
wait until it checks all table data... or not... :)

-----Original Message-----
From: Nilesh Govindarajan <lists(at)itech7(dot)com>
To: Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com>
Cc: Amit jain <amitjain(at)synechron(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] How to add constraints without validating data.
Date: Thu, 27 May 2010 21:45:25 +0530

How would disabling triggers help that ? He just wants to add
constraints without loss of data. I don't think he has any triggers.