| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | Don Baccus <dhogaza(at)pacifier(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Well, then you keep your darn columns |
| Date: | 2000-01-25 11:01:22 |
| Message-ID: | Pine.GSO.4.02A.10001251200520.11899-100000@Val.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julian Scarfe | 2000-01-25 13:23:58 | Re: [SQL] DISTINCT ON: speak now or forever hold your peace |
| Previous Message | Peter Eisentraut | 2000-01-25 10:59:04 | Re: [SQL] DISTINCT ON: speak now or forever hold your peace |