Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D09E24763FA for ; Mon, 11 Nov 2002 17:28:51 -0500 (EST) Received: from mail.reviewer.co.uk (frodo.reviewer.co.uk [213.232.121.13]) by postgresql.org (Postfix) with SMTP id 213644763A3 for ; Mon, 11 Nov 2002 17:28:40 -0500 (EST) Received: (qmail 12307 invoked from network); 11 Nov 2002 22:28:31 -0000 Received: from unknown (HELO LAIKA) (62.49.176.243) by mail.reviewer.co.uk with SMTP; 11 Nov 2002 22:28:31 -0000 From: "Robert John Shepherd" To: Subject: Bug in pg_dump Date: Mon, 11 Nov 2002 22:28:04 -0000 Message-ID: <006301c289d1$a9fac7b0$f3b0313e@LAIKA> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/77 X-Sequence-Number: 4859 ======================================================================== ==== POSTGRESQL BUG REPORT TEMPLATE ======================================================================== ==== Your name : Robert John Shepherd Your email address : robert@reviewer.co.uk System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium IV Operating System (example: Linux 2.0.26 ELF) : OpenBSD 3.1 PostgreSQL version (example: PostgreSQL-7.2.3): PostgreSQL-7.2.3 Compiler used (example: gcc 2.95.2) : 2.95.3 Please enter a FULL description of your problem: ------------------------------------------------ pg_dump incorrectly dumps db schema when tsearch functions etc are included Functions and definitions relating to table creation are specified correctly before tables are defined, however those needed for index creation are specified only after the indexes are created, causing errors during restore. Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- createdb testdb psql testdb < tsearch.sql create table t ( a text, b txtidx ); create index a_idx on t using GIST (b); pg_dump testdb > test.sql createdb testdb2 psql testdb2 < test.sql If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- Dump all functions and types before indexes