Re: How to add constraints without validating data.

Поиск
Список
Период
Сортировка
От Iñigo Martinez Lasala
Тема Re: How to add constraints without validating data.
Дата
Msg-id 1274977189.19383.51.camel@deimos
обсуждение исходный текст
Ответ на Re: How to add constraints without validating data.  (Nilesh Govindarajan <lists@itech7.com>)
Ответы Re: How to add constraints without validating data.  (Nilesh Govindarajan <lists@itech7.com>)
Список pgsql-admin
Constraints are special triggers, but triggers anyway.

So, If you truncate the table, create the contraint and then restore with triggers disabled, it could be faster that create the contraint and wait until it checks all table data... or not... :)



-----Original Message-----
From: Nilesh Govindarajan <lists@itech7.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: Amit jain <amitjain@synechron.com>, pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to add constraints without validating data.
Date: Thu, 27 May 2010 21:45:25 +0530

How would disabling triggers help that ? He just wants to add
constraints without loss of data. I don't think he has any triggers.


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

Предыдущее
От: Nilesh Govindarajan
Дата:
Сообщение: Re: How to add constraints without validating data.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: command tag logging