Re: full featured alter table? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: full featured alter table?
Date
Msg-id 20030613224828.GC1934@dcc.uchile.cl
Whole thread Raw
In response to Re: full featured alter table?  (Reynard Hilman <reynardmh@lightsky.com>)
List 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"

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Index not being used in MAX function (7.2.3)
Next
From: Tom Lane
Date:
Subject: Re: full featured alter table?