You have to disable triggers. Two options:
- Export table data, truncate table (if your table is fk source you will have a problem), add constraint and import exported data with --disable-triggers flag in pg_restore. - Perhaps you could add manually triger via pg_trigger table in pg_catalog whith an insert into this table. -----Original Message----- From: Amit jain <amitj...@synechron.com> To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org> Subject: [ADMIN] How to add constraints without validating data. Date: Thu, 27 May 2010 17:55:56 +0530 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: amitj...@synechron.com
