X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F66ED1D997 for ; Mon, 24 Nov 2003 14:02:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81447-09 for ; Mon, 24 Nov 2003 10:02:24 -0400 (AST) Received: from mwinf0601.wanadoo.fr (smtp6.wanadoo.fr [193.252.22.25]) by svr1.postgresql.org (Postfix) with ESMTP id 2EF31D1D630 for ; Mon, 24 Nov 2003 10:02:20 -0400 (AST) Received: from STAHER2 (AMarseille-206-2-1-2.w80-11.abo.wanadoo.fr [80.11.112.2]) by mwinf0601.wanadoo.fr (SMTP Server) with SMTP id E14E2340013C for ; Mon, 24 Nov 2003 15:02:22 +0100 (CET) From: "Armel HERVE" To: Subject: Problem with pg_dump / pg_restore Date: Mon, 24 Nov 2003 15:02:26 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/35 X-Sequence-Number: 4593 Hi everybody, I have a problem with dump / restore commands on PostgreSQL: pg_dump doesn't care about objects dependencies: - I create a view V1 on a table and then another view V2 on the same table - I modify V1 to use V2 pg_dump doesn't detect that V1 is using V2. So the command batch generated contains in first the creation of the view V1 which uses V2 and then the creation on the view V2 and it's impossible to restore a database with this generated file. My question is : how can I use pg_dump / pg_restore to generate a good backup file ? Thanks for your answers (and sorry for my poor english!!!) Armel