| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | ow <oneway_111(at)yahoo(dot)com>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Hannu Krosing <hannu(at)tm(dot)ee>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_restore and create FK without verification check |
| Date: | 2003-11-26 19:27:37 |
| Message-ID: | 20031126112529.E61947@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 26 Nov 2003, Tom Lane wrote:
> Quite honestly, I think they should check their foreign keys. In a
> partial restore situation there is no guarantee that the referenced
> table and the referencing table are being restored at the same time from
> the same dump. An override in that situation looks like a great tool
> for shooting yourself in the foot.
>
> People might be more interested in debating this topic with you if we
> hadn't discussed it at length just a couple months back. There wasn't
> consensus then that we had to offer an escape hatch, and you've not
> offered any argument that wasn't made before.
I actually thought the majority in the past discussion thought that an
escape hatch was a good idea, but that the discussion broke down in trying
to determine what sort of hatch that might be (iirc, it got off into the
general discussion of disabling constraints for normal operation as
opposed to at alter time).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2003-11-26 19:43:18 | Limiting factors of pg_largeobject |
| Previous Message | Kurt Roeckx | 2003-11-26 19:10:31 | Re: A rough roadmap for internationalization fixes |