Markus Schulz <msc(at)antzsystem(dot)de> writes:
> i have some trouble with dumping and restoring a database with
> postgresql 7.4.7-6sarge4 (debian sarge).
> What can i do to enforce the order of plpgsql functions prior to all
> table structures?
Update to PG 8.x --- IIRC 8.0 was the first release in which pg_dump
really understood about dependencies properly. 7.x is dumping basically
in creation order, which falls down as soon as you start using ALTER
TABLE to create dependencies that weren't there originally.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2007-02-27 17:47:46|
|Subject: Re: Building a record in a function|
|Previous:||From: A. Kretschmer||Date: 2007-02-27 17:28:51|
|Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint|