Improve error message and hint for ALTER COLUMN TYPE can't-cast failure.
Tom Lane <tgl@sss.pgh.pa.us>
Improve error message and hint for ALTER COLUMN TYPE can't-cast failure. We already tried to improve this once, but the "improved" text was rather off-target if you had provided a USING clause. Also, it seems helpful to provide the exact text of a suggested USING clause, so users can just copy-and-paste it when needed. Per complaint from Keith Rarick and a suggestion from Merlin Moncure. Back-patch to 9.2 where the current wording was adopted.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/tablecmds.c | modified | +20 −5 |
| src/test/regress/expected/alter_table.out | modified | +5 −2 |
| src/test/regress/sql/alter_table.sql | modified | +1 −0 |