Re: [BUGS] pg_dump function dumped after required for table definition

#1

Reece Hart <reece (AT) in-machina (DOT) com> writes:

Quote:

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.

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 :-(

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

--WZxAcDzU5g8uWBfq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Tom Lane (tgl (AT) sss (DOT) pgh.pa.us) wrote:

Quote:

Reece Hart <reece (AT) in-machina (DOT) 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?

--WZxAcDzU5g8uWBfq
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/rNOurzgMPqB3kigRAmbSAJ9fCDFba3HtcoZjp4Mzecf8GVD9Lg CfQvYD
32Qi72NcPjj6PSP5lmdrjck=
=Cdpg
-----END PGP SIGNATURE-----

--WZxAcDzU5g8uWBfq--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] pg_dump function dumped after required for table definition

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] pg_dump function dumped after required for table definition - 11-07-2003 , 10:13 PM

Re: [BUGS] pg_dump function dumped after required for table definition - 11-08-2003 , 05:32 AM