On Mon, 2004-07-12 at 08:29, SZÛCS Gábor wrote:
> Dear Fellow Countymen,
>
> I fear none of your answers are acceptable for me. Also, from Csaba's
> answer, this sounds to me more like a bug in pg_dump v7.3.

It is a bug (or a missing feature) that should be solved with v7.5 for
restoring to 7.5 or later database.

Until then, you'll need to re-order the dump by hand (splitting data
from schema can be useful).


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thanks Rod.

Checked, and So do you say, this problem persists in dbs dumped from 7.4 to
7.4 too? i.e. upgrading to 7.4 (which we tested for quite some time now)
won't help?

(...)

trying dump confirmed this :( Even tried adding a line to pg_depend but
didn't seem to change anything.

G.
%----------------------- cut here -----------------------%
\end

----- Original Message -----
From: "Rod Taylor" <pg [at] rbt.ca>
Sent: Monday, July 12, 2004 2:51 PM
Subject: Re: [SQL] Constraint->function dependency and dump in 7.3


> On Mon, 2004-07-12 at 08:29, SZ=DBCS G=E1bor wrote:
> > Dear Fellow Countymen,
> >
> > I fear none of your answers are acceptable for me. Also, from Csaba's
> > answer, this sounds to me more like a bug in pg_dump v7.3.
>
> It is a bug (or a missing feature) that should be solved with v7.5 for
> restoring to 7.5 or later database.
>
> Until then, you'll need to re-order the dump by hand (splitting data
> from schema can be useful).
>
>


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster