Add IF NOT EXISTS for CREATE SERVER and CREATE USER MAPPING
Andrew Dunstan <andrew@dunslane.net>
Add IF NOT EXISTS for CREATE SERVER and CREATE USER MAPPING There is still some inconsistency with the error messages surrounding foreign servers. Some use the word "foreign" and some don't. My inclination is to remove all such uses of "foreign" on the basis that the CREATE/ALTER/DROP SERVER commands don't use the word. However, that is left for another day. In this patch I have kept to the existing usage in the affected commands, which omits "foreign". Anastasia Lubennikova, reviewed by Arthur Zakirov and Ashtosh Bapat. Discussion: http://postgr.es/m/7c2ab9b8-388a-1ce0-23a3-7acf2a0ed3c6@postgrespro.ru
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/create_server.sgml | modified | +13 −1 |
| doc/src/sgml/ref/create_user_mapping.sgml | modified | +13 −1 |
| src/backend/commands/foreigncmds.c | modified | +33 −5 |
| src/backend/parser/gram.y | modified | +23 −0 |
| src/include/nodes/parsenodes.h | modified | +2 −0 |
| src/test/regress/expected/foreign_data.out | modified | +6 −0 |
| src/test/regress/sql/foreign_data.sql | modified | +3 −0 |
Documentation touched
Discussion
- IF NOT EXISTS option for CREATE SERVER and CREATE USER MAPPING statements 8 messages · 2017-01-13 → 2017-03-15