pgsql: Add a transform function for numeric typmod coercisions. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Add a transform function for numeric typmod coercisions.
Date
Msg-id E1RuoXA-000141-Os@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Add TIMING option to EXPLAIN, to allow eliminating of timing ove
Next
From: Robert Haas
Date:
Subject: pgsql: Add a transform function for varbit typmod coercisions.