X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9C3FBD1B1C7 for ; Tue, 13 Jul 2004 14:20:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55988-02 for ; Tue, 13 Jul 2004 17:20:44 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id A2A75D1B170 for ; Tue, 13 Jul 2004 14:20:41 -0300 (ADT) Received: from [134.22.68.4] (dyn-68-4.tor.dsl.tht.net [134.22.68.4]) by tht.net (Postfix) with ESMTP id E9AB776B3A; Tue, 13 Jul 2004 13:20:43 -0400 (EDT) Subject: Re: Constraint->function dependency and dump in 7.3 From: Rod Taylor To: =?iso-8859-2?Q?SZ=DBCS_G=E1bor?= Cc: pgsql-sql@postgresql.org In-Reply-To: <01f401c468f6$90905c80$0403a8c0@fejleszt4> References: <00a001c4680b$f14c60a0$0403a8c0@fejleszt4> <1089636713.58812.37.camel@jester> <01f401c468f6$90905c80$0403a8c0@fejleszt4> Content-Type: text/plain Message-Id: <1089739239.48027.64.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 13 Jul 2004 13:20:40 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/81 X-Sequence-Number: 18333 > Checked, and So do you say, this problem persists in dbs dumped from 7.4 to > 7.4 too? i.e. upgrading to 7.4 (which we tested for quite some time now) > won't help? There may have been some minor fiddling to make it easier, but I wouldn't call it fixed by any means. > trying dump confirmed this :( Even tried adding a line to pg_depend but > didn't seem to change anything. The 7.5 version of pg_dump will be the first one to use pg_depend to attempt to get the object order correct. I would hold off on an upgrade until October (or so) and goto 7.5 instead.