From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PG_DUMP and Adding columns/Types |
Date: | 2002-10-15 04:06:00 |
Message-ID: | 1034654760.1711.5.camel@lerlaptop.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-15 04:22:33 | Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c |
Previous Message | Tom Lane | 2002-10-15 04:01:16 | Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c |