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


14 Oct 2002 23:06:00 -0500
Larry Rosenman <ler@lerctr.org>
PG_DUMP and Adding columns/Types