| From: | Robert Haas <rhaas(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Add a transform function for numeric typmod coercisions. |
| Date: | 2012-02-07 17:08:48 |
| Message-ID: | E1RuoXA-000141-Os@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Add a transform function for numeric typmod coercisions.
This enables ALTER TABLE to skip table and index rebuilds when a column
is changed to an unconstrained numeric, or when the scale is unchanged
and the precision does not decrease.
Noah Misch, with a few stylistic changes and a fix for an OID
collision by me.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/3cc0800829a6dda5347497337b0cf43848da4acf
Modified Files
--------------
src/backend/utils/adt/numeric.c | 48 ++++++++++++++++++++++++++++++++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 4 ++-
src/include/utils/builtins.h | 1 +
4 files changed, 53 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-02-07 17:43:09 | pgsql: Add a transform function for varbit typmod coercisions. |
| Previous Message | Robert Haas | 2012-02-07 16:29:48 | pgsql: Add TIMING option to EXPLAIN, to allow eliminating of timing ove |