Improve error message and hint for ALTER COLUMN TYPE can't-cast failure.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Jun 2015 15:54:03 +0000 (11:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Jun 2015 15:54:03 +0000 (11:54 -0400)
commit1c150f8aa759aaa9e5761da79653894510d868db
treeff70ef21077d43c2a9b45e9bf35c30b447d67983
parente9eebbaebf8a494c40b316e203287fd71dd0fd90
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.
src/backend/commands/tablecmds.c
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql