From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Nilesh Govindarajan <lists@itech7.com>
Cc: Amit jain <amitjain@synechron.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to add constraints without validating data.
Date: Thu, 27 May 2010 18:19:49 +0200
Message-ID: <1274977189.19383.51.camel@deimos> (raw)
In-Reply-To: <AANLkTilVBVMQF7wEmRgQRqEUKf1YQYQ4Jc3tdIV_dqbV@mail.gmail.com>
References: <4BFE64D4.4020107@synechron.com>
<1274976054.19383.37.camel@deimos>
<AANLkTilVBVMQF7wEmRgQRqEUKf1YQYQ4Jc3tdIV_dqbV@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com, lists@itech7.com, amitjain@synechron.com
Subject: Re: How to add constraints without validating data.
In-Reply-To: <1274977189.19383.51.camel@deimos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox