Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9B3A7632777 for ; Thu, 27 May 2010 09:31:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 87647-02 for ; Thu, 27 May 2010 12:31:13 +0000 (UTC) X-Greylist: delayed 00:05:08.696853 by SQLgrey-1.7.6 Received: from smtp172.dfw.emailsrvr.com (smtp172.dfw.emailsrvr.com [67.192.241.172]) by mail.postgresql.org (Postfix) with ESMTP id EE30E632755 for ; Thu, 27 May 2010 09:31:14 -0300 (ADT) Received: from relay17.relay.dfw.mlsrvr.com (localhost [127.0.0.1]) by relay17.relay.dfw.mlsrvr.com (SMTP Server) with ESMTP id 7526C2C704B8 for ; Thu, 27 May 2010 08:26:04 -0400 (EDT) Received: by relay17.relay.dfw.mlsrvr.com (Authenticated sender: amitjain-AT-synechron.com) with ESMTPSA id 9396F2C7246E for ; Thu, 27 May 2010 08:26:03 -0400 (EDT) Message-ID: <4BFE64D4.4020107@synechron.com> Date: Thu, 27 May 2010 17:55:56 +0530 From: Amit jain User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: How to add constraints without validating data. Content-Type: multipart/alternative; boundary="------------060509050208000206040209" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201005/261 X-Sequence-Number: 34734 This is a multi-part message in MIME format. --------------060509050208000206040209 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi Gurus Is there any way in postgreSQL to apply constraints forcefully without checking/validating Data ? It should validate only those records which comes after constraints are applied. I need this help as data is already loaded in database but "ALTER TABLE" sql for adding CONSTRAINTS is taking enormous time. Thanks for ideas/suggestion in Advance !! -- Regards, *Amit Jain* *Synechron Technologies Pvt. Ltd.* 4th Floor, B Wing, Block 1.2, Embassy Techzone, Rajiv Gandhi Infotech Park, Hinjewadi Phase II, Pune 411 057. Phone : +91.20.40262000 Ext 2163 | Mobile:+91.9561298565 |VoIP : +1.732.415.0894 http://www.synechron.com MailTo: amitjain@synechron.com --------------060509050208000206040209 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Gurus

Is there any way in postgreSQL to apply constraints forcefully without checking/validating Data ? It should validate only those records which comes after constraints are applied.

I need this help as data is already loaded in database but "ALTER TABLE" sql for adding CONSTRAINTS is taking enormous time.

Thanks for ideas/suggestion in Advance !!

Regards,

Amit Jain 
Synechron Technologies Pvt. Ltd. 4th  Floor, B Wing, Block 1.2, Embassy Techzone,
Rajiv Gandhi Infotech Park, Hinjewadi Phase II, Pune 411 057. 
Phone : +91.20.40262000 Ext 2163 | Mobile:+91.9561298565 | VoIP : +1.732.415.0894
http://www.synechron.com  MailTo: amitjain@synechron.com

--------------060509050208000206040209--