Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7C530475E4A for ; Fri, 15 Nov 2002 14:24:18 -0500 (EST) Received: from jester.senspire.com (nat.inquent.com [216.6.14.45]) by postgresql.org (Postfix) with ESMTP id EFB00475AE5 for ; Fri, 15 Nov 2002 14:24:16 -0500 (EST) Received: from jester.senspire.com (localhost [127.0.0.1]) by jester.senspire.com (8.12.6/8.12.6) with ESMTP id gAFJOx5e031904 for ; Fri, 15 Nov 2002 14:24:59 -0500 (EST) (envelope-from rbt@rbt.ca) Received: (from rbt@localhost) by jester.senspire.com (8.12.6/8.12.6/Submit) id gAFIpFaH019063; Fri, 15 Nov 2002 13:51:15 -0500 (EST) X-Authentication-Warning: jester.senspire.com: rbt set sender to rbt@rbt.ca using -f Subject: Re: Bug in pg_dump From: Rod Taylor To: Robert John Shepherd Cc: pgsql-bugs@postgresql.org In-Reply-To: <006301c289d1$a9fac7b0$f3b0313e@LAIKA> References: <006301c289d1$a9fac7b0$f3b0313e@LAIKA> Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Message-Id: <1037386274.14810.89.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 15 Nov 2002 13:51:15 -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/85 X-Sequence-Number: 4867 > If you know how this problem might be fixed, list the solution below: > --------------------------------------------------------------------- > > Dump all functions and types before indexes This causes errors in other ways. The true solution is to have pg_dump use a decent dependency tracking mechanism. 7.4 should hold the fix for pg_dump, although 7.3 has the dependency tracking mechanism. -- Rod Taylor