thanks. i've looked into doing it manually. if anyone else has suggestions (e.g., are there smarter dumping tools or software based workarounds, even pg_dump parsers that will do the reordering), please, chime in :).
tiger On Thu, 9 Sep 2004 14:39:15 +0800, Sherwin Daganato <[EMAIL PROTECTED]> wrote: > On Thu, Sep 09, 2004 at 01:31:38PM +0800, Bopolissimus Platypus Jr wrote: > > is it possible to force postgresql to defer looking for definitions? or > > somehow to make things like this work? > > I've encountered this before. I did exactly what the docs suggested. > i.e. manually reorder the dump. > > FROM http://www.postgresql.org/docs/7.4/static/backup.html > > 22.1.4. Caveats > > pg_dump (and by implication pg_dumpall) has a few limitations which > stem from the difficulty of reconstructing certain information from the > system catalogs. > > Specifically, the order in which pg_dump writes the objects is not very > sophisticated. This can lead to problems for example when functions are > used as column default values. The only answer is to manually reorder > the dump. If you created circular dependencies in your schema then you > will have more work to do. > > -- > $_=q:; # SHERWIN # > 70;72;69;6e;74;20; > 27;4a;75;73;74;20; > 61;6e;6f;74;68;65; > 72;20;50;65;72;6c; > 20;6e;6f;76;69;63; > 65;27;:;;s=~?(..); > ?=pack q$C$,hex$1; > ;;;=egg;;;;eval;;; > -- Gerald Timothy Quimpo http://bopolissimus.sni.ph [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78" Mene sakhet ur-seveh -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
