From: Amit jain <amitjain@synechron.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: How to add constraints without validating data.
Date: Thu, 27 May 2010 17:55:56 +0530
Message-ID: <4BFE64D4.4020107@synechron.com> (raw)
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 <http://www.synechron.com/; MailTo: amitjain@synechron.com <mailto:nilnandanj@synechron.com>
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: amitjain@synechron.com
Subject: Re: How to add constraints without validating data.
In-Reply-To: <4BFE64D4.4020107@synechron.com>
* 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