Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8FDAB4768ED for ; Mon, 13 May 2002 18:13:17 -0400 (EDT) Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (Postfix) with ESMTP id DA67D47611D for ; Mon, 13 May 2002 17:01:58 -0400 (EDT) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 390 for ; Mon, 13 May 2002 14:48:22 -0600 Message-ID: <3CE02FF5.ABDC8CC@waterford.org> Date: Mon, 13 May 2002 15:28:22 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: pg_dumpall Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/124 X-Sequence-Number: 7760 Hello, I am upgrading from Postgres7.1.3 to Postgres7.2.1 and dumped all the data to a file with pg_dumpall -o > dump When I go throught the dump file it turns out that some views are created before the base relations are created. When I try to import the dump file in Postgres 7.2.1 some of the views are not created because if this. Why the order of created data objects is wrong? I kept view definitions in several files, but I would still like to know how to move data between releases consistently. thanks, Oleg