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 по дате отправления: