Re: pg_dump function dumped after required for table definition

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Reece Hart <reece@in-machina.com> writes:
> > I have a hunch about why this happens and is rare. The pftype_id_lookup
> > function was created AFTER some of the tables using 'alter table set
> > default ...'. Thus, the function's OID is greater than the OID of the
> > tables which use them.
>=20
> Yeah, this is a well-known problem in pg_dump.  We need to revise it to
> pay attention to the dependency information that's now available in
> pg_depend.  At the moment your only alternative is to manually fix the
> reload order using pg_restore's features for controlling the reload
> order ... which features would never have existed in the first place
> if we'd had this problem nailed :-(

I'm guessing this isn't going to get fixed before 7.4 is released, eh?