| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Thom Brown <thom(at)linux(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED |
| Date: | 2011-06-03 17:02:51 |
| Message-ID: | 1307120536-sup-3663@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2011-06-03 17:04:15 | Re: Streaming solution and v3.1 protocol |
| Previous Message | Alvaro Herrera | 2011-06-03 17:01:38 | Re: BUG #6041: Unlogged table was created bad in slave node |