From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Reynard Hilman <reynardmh(at)lightsky(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: full featured alter table? |
Date: | 2003-06-13 22:48:28 |
Message-ID: | 20030613224828.GC1934@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 13, 2003 at 05:05:32PM +0000, Reynard Hilman wrote:
> As far as I remember when working with Oracle, it allows you to change
> the data as long as you don't lose or corrupt your data. So, for
> example, changing varchar(20) to varchar(40) should be ok, but the
> reverse might not be ok. It'd be nice if it allows you to change the
> type from varchar(40) to varchar(20) if you don't have any data that is
> larger than varchar(20). I don't know how much complexity that will add,
> though. well that's just some idea from me.
It's not _that_ hard IMHO. It's just that no one has ever bothered to
code it.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El dia que dejes de cambiar dejaras de vivir"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-13 22:49:01 | Re: full featured alter table? |
Previous Message | weigelt | 2003-06-13 22:44:25 | Re: full featured alter table? |