Thread: pgsql: Add a transform function for numeric typmod coercisions.

pgsql: Add a transform function for numeric typmod coercisions.

From
Robert Haas
Date:
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(-)