PG_DUMP and Adding columns/Types

Looking at a 7.2.3 dump of a database I've been using for development, I
noticed that a type that was used in a ALTER TABLE ADD COLUMN (for an
existing table) was CREATE TYPE **AFTER** the CREATE TABLE for said
table.

I suspect this will give me grief on reload.

(I can get around it, but I thought I'd mention the issue).

Basically, I defined a comments table, then decided I wanted to use the
contrib/tsearch module, so I added the contrib/tsearch stuff, and then
did a ALTER TABLE ADD COLUMN comments_idx txtidx.

In the pg_dump (and pg_dump -s), I note that the CREATE TYPE for txtidx
happens AFTER the CREATE TABLE comments.

I haven't tried to reload this dump script yet.

LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749