On Thu, May 27, 2010 at 9:30 PM, Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx> wrote: > 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 <amitjain@xxxxxxxxxxxxx> > To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx> > Subject: 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: amitjain@xxxxxxxxxxxxx > > > > > How would disabling triggers help that ? He just wants to add constraints without loss of data. I don't think he has any triggers. -- Nilesh Govindarajan Facebook: nilesh.gr Twitter: nileshgr Website: www.itech7.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
