In ALTER COLUMN TYPE, strip any implicit coercion operations appearing
Tom Lane <tgl@sss.pgh.pa.us>
In ALTER COLUMN TYPE, strip any implicit coercion operations appearing at the top level of the column's old default expression before adding an implicit coercion to the new column type. This seems to satisfy the principle of least surprise, as per discussion of bug #1290.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_table.sgml | modified | +17 −1 |
| src/backend/commands/tablecmds.c | modified | +9 −2 |
| src/backend/optimizer/util/clauses.c | modified | +36 −1 |
| src/include/optimizer/clauses.h | modified | +3 −1 |