Steve Ingram <ingram(at)samsixedd(dot)com> writes:
> When I pg_dump out the database, it outputs all the tables, functions, types
> as you'd expect, but it outputs table definitions that reference postgis
> functions/types *before* the functions/types themselves.
Yeah, this is pretty likely if you did any ALTER TABLE or similar
commands anywhere along the line. The dump order is dependent on the
original creation order of the objects (tables, functions, etc) and so
it's pretty easy to break it by adding columns or indexes to
8.0's pg_dump attempts to deal with this by paying attention to
dependencies, but no earlier release does anything at all credible.
FWIW, pg_restore does have options to alter the reload order, which
may be an easier workaround than editing a textual dump.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: zhongxb||Date: 2004-08-28 04:03:32|
|Subject: pgsql 8.0 beta1 patch for token and timezone|
|Previous:||From: Gaetano Mendola||Date: 2004-08-27 18:31:30|
|Subject: Re: BUG #1231: Probelm with transactions in stored code.|