On Mon, 24 Jan 2000, The Hermit Hacker wrote:
> On Mon, 24 Jan 2000, Don Baccus wrote:
>
> > At 03:44 PM 1/24/00 -0400, The Hermit Hacker wrote:
> >
> > >Oh, there is a second drawback to it though ...
> > >
> > >DROP COLUMN name
> > >ADD COLUMN name <of a different type>
> > >
> > >Then what? :(
> >
> > I don't understand...the idea is to make the old column name
> > invisible, and therefore "add column" won't see it either.
>
> so the pg_* file that maintains the 'fields' in a table would have two
> fields of the same name, one enabled, one disabled?
The entries in pg_attribute have oids as well ...
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden