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@xxxxxxxxxx>
To: Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx>
Cc: Amit jain <amitjain@xxxxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: 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.
