Re: pg_restore and FK constraints with large dbs - Mailing list pgsql-admin

From ow
Subject Re: pg_restore and FK constraints with large dbs
Date
Msg-id 20031117233806.16693.qmail@web21408.mail.yahoo.com
Whole thread Raw
In response to Re: pg_restore and FK constraints with large dbs  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: pg_restore and FK constraints with large dbs
List pgsql-admin
--- Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
> Well, I've been trying to deal with the particular case at hand, ie, get
> your load in a more reasonable amount of time assuming that you had more
> constraints and this was going to be a particular problem for you in the
> immediate term.  I've mentioned that there's likely to be future
> development on the issue in this thread already and that there was a
> recent discussion on the topic that occurred a bit late to do anything for
> 7.4.  I can't change the past to suit your desires, sorry, the best I can
> do is point you towards getting a solution for the future.
>

Thanks, you've been very helpful and I appreciate the effort.

In case if there's no immediate solution, the solution could be something like
"yes, we understand the importance of the raised issue and we intent to
implement a fix for it in 7.5/8.0/or whatever".

Personally, I see the fix as the ability for the superuser to issue "SET
suspend_fk_checks(or whatever)=true/false" on the respective connection and
perhaps the respective pg_restore option.

Anything I can do to make this happen? (am not a C-developer but perhaps could
help with testing).

Thanks





__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Debugging PL/PGSQL
Next
From: Stephan Szabo
Date:
Subject: Re: pg_restore and FK constraints with large dbs