Re: pg_dump and restore problem with function as DEFAULT-Constraint

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint
Date: 2007-02-27 19:37:45
Message-ID: 20070227193745.GA8272@KanotixBox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Markus Schulz <msc(at)antzsystem(dot)de> schrieb:
> > You can use pg_restore with -l to generate a listfile for all objects
> > in the database. Then you can reorder this ($EDITOR) and then use -L
> > to use this ordered listfile to enforce the right order of objects. I
> > hope this helps you.
>
> thanks, nice idea. I will try it.

I have never used this, please tell me if you have success with this.
(And yes, i hope, i never need this...)

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2007-02-27 19:56:34 Re: How often do I need to reindex tables?
Previous Message Dhaval Shah 2007-02-27 19:26:02 How often do I need to reindex tables?