Re: RI triggers and schemas

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: RI triggers and schemas
Дата
Msg-id 010301c1d94c$078122d0$0200a8c0@SOL
обсуждение исходный текст
Ответ на RI triggers and schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Yeah, although it'd still be a good idea probably to convert the dump form
> to ALTER TABLE in any case.  The one downside that was brought up in the
> past was the time involved in checking dumped (presumably correct) data
> when the constraint is added to very large tables.  I can probably make
> that faster since right now it's just running the check on each row,
> but it'll still be slow on big tables possibly.  Another option would
> be to have an argument that would disable the check on an add constraint,
> except that wouldn't work for unique/primary key.

Maybe it could be a really evil SET CONSTRAINTS command like:

SET CONSTRAINTS UNCHECKED;

...

Chris



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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: RI triggers and schemas
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: RI triggers and schemas