Postgres Pro
Downloads
Home   >   mailing lists

Re: How to add constraints without validating data. - Mailing list pgsql-admin

From Iñigo Martinez Lasala
Subject Re: How to add constraints without validating data.
Date
Msg-id 1274977189.19383.51.camel@deimos
Whole thread Raw
In response to Re: How to add constraints without validating data.  (Nilesh Govindarajan <lists@itech7.com>)
Responses Re: How to add constraints without validating data.  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-admin
Tree view
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@itech7.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: Amit jain <amitjain@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.

pgsql-admin by date:

Previous
From: Nilesh Govindarajan
Date:
Subject: Re: How to add constraints without validating data.
Next
From: Tom Lane
Date:
Subject: Re: command tag logging