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 3107FD1B1DC for ; Tue, 13 Jul 2004 13:30:04 -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 26185-09 for ; Tue, 13 Jul 2004 16:29:59 +0000 (GMT) Received: from fe07.axelero.hu (fe07.axelero.hu [195.228.240.95]) by svr1.postgresql.org (Postfix) with ESMTP id 0904CD1B198 for ; Tue, 13 Jul 2004 13:29:52 -0300 (ADT) Received: from fe07 (localhost-02 [127.0.2.1]) by fe07.axelero.hu (8.12.11/8.12.11) with SMTP id i6DGTp9U033162 for ; Tue, 13 Jul 2004 18:29:51 +0200 (CEST) Received: from fe07.axelero.hu [127.0.2.1] via SMTP gateway by fe07 [195.228.240.95]; id A0817E3B1E9 at Tue, 13 Jul 2004 18:29:51 +0200 Received: from fejleszt4 (121-248-182-81.adsl-fixip.axelero.hu [81.182.248.121]) by fe07.axelero.hu (8.12.11/8.12.11) with SMTP id i6DGTmPg033085 for ; Tue, 13 Jul 2004 18:29:49 +0200 (CEST) Message-ID: <01f401c468f6$90905c80$0403a8c0@fejleszt4> From: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" To: References: <00a001c4680b$f14c60a0$0403a8c0@fejleszt4> <1089636713.58812.37.camel@jester> Subject: Re: Constraint->function dependency and dump in 7.3 Date: Tue, 13 Jul 2004 18:29:23 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-RAVMilter-Version: 8.4.3(snapshot 20030217) (fe07.axelero.hu) Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by fe07.axelero.hu id i6DGTmPg033085 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/80 X-Sequence-Number: 18332 Thanks Rod. 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? (...) trying dump confirmed this :( Even tried adding a line to pg_depend but didn't seem to change anything. G. %----------------------- cut here -----------------------% \end ----- Original Message -----=20 From: "Rod Taylor" Sent: Monday, July 12, 2004 2:51 PM Subject: Re: [SQL] Constraint->function dependency and dump in 7.3 > On Mon, 2004-07-12 at 08:29, SZ=DBCS G=E1bor wrote: > > Dear Fellow Countymen, > > > > I fear none of your answers are acceptable for me. Also, from Csaba's > > answer, this sounds to me more like a bug in pg_dump v7.3. > > It is a bug (or a missing feature) that should be solved with v7.5 for > restoring to 7.5 or later database. > > Until then, you'll need to re-order the dump by hand (splitting data > from schema can be useful). > >