========================================================================
====
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