pgsql: Fix ADD IF NOT EXISTS used in conjunction with ALTER TABLE ONLY

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: Fix ADD IF NOT EXISTS used in conjunction with ALTER TABLE ONLY

Greg Stark
Fix ADD IF NOT EXISTS used in conjunction with ALTER TABLE ONLY

The flag for IF NOT EXISTS was only being passed down in the normal
recursing case. It's been this way since originally added in 9.6 in
commit 2cd40adb85 so backpatch back to 9.6.

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9e6cd794c282499aa0d2d31166c023cda0682e67

Modified Files
--------------
src/backend/commands/tablecmds.c          | 2 +-
src/test/regress/expected/alter_table.out | 6 ++++++
src/test/regress/sql/alter_table.sql      | 4 ++++
3 files changed, 11 insertions(+), 1 deletion(-)