--- ow <oneway_111@yahoo.com> wrote:
> IMHO, not only data need to loaded before FK constraints are created but also
> there has got to be a feature to allow creation of an FK constraint WITHOUT
> doing the verification that all loaded/existing records satisfy the FK
> constraint. The ability to create a FK constraint without verification of
> existing records should exist by itself (maybe only to superuser) and also as
> an option in pg_restore.
>
> More details:
> http://archives.postgresql.org/pgsql-admin/2003-11/msg00308.php
> http://archives.postgresql.org/pgsql-admin/2003-11/msg00323.php
>
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?
Thanks
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/