Re: Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?
Date
Msg-id 20130905195337.GE6067@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?  (Greg Stark <stark@mit.edu>)
Responses Re: [HACKERS] Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?
List pgsql-hackers
Greg Stark escribió:

> The main difficulty is that Postgres is very extensible. So to implement
> this you need to think bigger than NUMERIC. It should also be possible to
> alter a column from varchar(5) to varchar(10) for example (but not the
> other way around).

We already allow that.  See commits
8f9fe6edce358f7904e0db119416b4d1080a83aa and
3cc0800829a6dda5347497337b0cf43848da4acf

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: lcr v5 - introduction of InvalidCommandId
Next
From: Andres Freund
Date:
Subject: Re: [RFC] Extend namespace of valid guc names