Re: pg_dump bug? - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_dump bug?
Date
Msg-id 3763.1067438008@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump bug?  ("Thilo Hille" <thilo@resourcery.de>)
List pgsql-novice
"Thilo Hille" <thilo@resourcery.de> writes:
> I am using postgresl 7.2.3. Yesterday i have dumped a database using pg_dump
> everthing was fine, but the dump was in the wrong order. There were indexes
> and views createded before the corresponding table was created.

There are some bugs along that line, particularly in older releases.
If you're using one of the archive output formats then pg_restore can
be used to alter the restore order into something that will work.

            regards, tom lane

pgsql-novice by date:

Previous
From: Jim Beckstrom
Date:
Subject: foxpro to postgresql 7.x
Next
From: Tom Lane
Date:
Subject: Re: logging messages this time