Re: [HACKERS] Well, then you keep your darn columns - Mailing list pgsql-hackers

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