| From: | Amit jain <amitjain(at)synechron(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How to add constraints without validating data. |
| Date: | 2010-05-27 12:25:56 |
| Message-ID: | 4BFE64D4.4020107@synechron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)synechron(dot)com <mailto:nilnandanj(at)synechron(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nilesh Govindarajan | 2010-05-27 12:34:35 | Re: How to add constraints without validating data. |
| Previous Message | Andreas Schmitz | 2010-05-27 07:54:00 | Re: Corrupted database - how to recover |