Re: pg_restore and create FK without verification check

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:02:11
Message-ID: 20031126105726.P61205@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Wed, 26 Nov 2003, ow wrote:

> > 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'm simply presenting a problem for which I currently do not see any solution
> (it's very important for us to be able to restore db within a reasonable amount
> of time). If there's no solution and none is planned, then we cannot use pgsql,
> can we?

You can make your own solution, that's the nice thing about open source
stuff. If you wanted to go the SET variable route to control alter time
checks of CHECK and FOREIGN KEY constraints, it's almost certainly less
than an hours worth of work.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kurt Roeckx 2003-11-26 19:10:31 Re: A rough roadmap for internationalization fixes
Previous Message Jonathan Gardner 2003-11-26 18:58:22 Re: Materialized views proposal