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