Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED
Дата
Msg-id 1307120536-sup-3663@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Excerpts from Robert Haas's message of vie jun 03 09:34:03 -0400 2011:

> > Just a note that since Alvaro created a patch to provide similar
> > functionality for constraints, I identified an issue with database
> > dumps, which apparently affects invalid foreign keys too:
> > http://archives.postgresql.org/pgsql-hackers/2011-06/msg00162.php
> >
> > In other words, a database containing foreign keys that hasn't yet
> > been validated will not produce a dump containing the necessary NOT
> > VALID parameters.  This would be fixed by Alvaro's patch.
> 
> Sounds like someone needs to extract and apply that portion of
> Alvaro's patch.  I've added this to the open items list.

It's already a separate patch; I'll apply soon.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Domains versus polymorphic functions, redux
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Estimating total amount of shared memory required by postmaster