Horton

Fix ALTER TABLE error message

Álvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 7bbc46213de9301795da90923a015070239c1fcc
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2025-03-04T19:07:30Z
Releases: 18.0 
Fix ALTER TABLE error message

This bogus error message was introduced in 2013 by commit f177cbfe676d,
because of misunderstanding the processCASbits() API; at the time, no
test cases were added that would be affected by this change.  Only in
ca87c415e2fc was one added (along with a couple of typos), with an XXX
note that the error message was bogus.  Fix the whole, add some test
cases.

Backpatch all the way back.

Reviewed-by: Nathan Bossart <nathandbossart@gmail.com>
Discussion: https://postgr.es/m/202503041822.aobpqke3igvb@alvherre.pgsql

Files

PathChange+/−
src/backend/parser/gram.y modified +1 −1
src/test/regress/expected/constraints.out modified +3 −4
src/test/regress/expected/foreign_key.out modified +9 −1
src/test/regress/sql/constraints.sql modified +1 −2
src/test/regress/sql/foreign_key.sql modified +3 −1

Discussion