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

Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
> 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...)

this works.

There is only one general problem with pg_restore, it breaks if there
were errors cause of duplicates. If you have some stuff in your
template and the same in your dump you must solve this manually.
Perhaps there should be an "-ignore-errors" option.

--
Markus Schulz