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: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
