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 <li...@itech7.com> To: Iñigo Martinez Lasala <imarti...@vectorsf.com> Cc: Amit jain <amitj...@synechron.com>, pgsql-admin@postgresql.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.
