Re: RI triggers and schemas
От | Christopher Kings-Lynne |
---|---|
Тема | Re: RI triggers and schemas |
Дата | |
Msg-id | 007801c1d942$887459c0$0200a8c0@SOL обсуждение исходный текст |
Ответ на | Re: RI triggers and schemas (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: RI triggers and schemas
|
Список | 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 по дате отправления: