Re: pg_restore and create FK without verification check

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_restore and create FK without verification check
Date: 2003-11-26 10:09:31
Message-ID: 3FC47BDB.9060404@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ow wrote:

>
>It appears there's not a lot of interest in discussing the possibility of FK
>constraint creation WITHOUT the verification check. How then should one handle
>the situation with pg_restore and large dbs where creation of FK constraint(s)
>may take hours?
>
>

I'd prefer a backup/restore method that dumps physical data, so at
restore time there's no need for recreation of FKs. But I didn't see any
feedback on this proposal either.

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-11-26 10:35:25 Re: pg_restore and create FK without verification check
Previous Message Hans-Jürgen Schönig 2003-11-26 09:06:52 statistics about tamp tables ...