--- ow <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
