Bug in pg_dump

From: "Robert John Shepherd" <robert(at)reviewer(dot)co(dot)uk>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Bug in pg_dump
Date: 2002-11-11 22:28:04
Message-ID: 006301c289d1$a9fac7b0$f3b0313e@LAIKA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

========================================================================
====
POSTGRESQL BUG REPORT TEMPLATE
========================================================================
====

Your name : Robert John Shepherd
Your email address : robert(at)reviewer(dot)co(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message RP 2002-11-12 03:56:12 Install problem
Previous Message Tom Lane 2002-11-11 17:09:52 Re: Interval+tz-tz gives unexpected result