How to add constraints without validating data.

Поиск
Список
Период
Сортировка
От Amit jain
Тема How to add constraints without validating data.
Дата
Msg-id 4BFE64D4.4020107@synechron.com
обсуждение исходный текст
Ответы Re: How to add constraints without validating data.  (Nilesh Govindarajan <lists@itech7.com>)
Re: How to add constraints without validating data.  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
Список 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  MailTo: amitjain@synechron.com



В списке pgsql-admin по дате отправления:

Предыдущее
От: Andreas Schmitz
Дата:
Сообщение: Re: Corrupted database - how to recover
Следующее
От: Nilesh Govindarajan
Дата:
Сообщение: Re: How to add constraints without validating data.