Horton

Update MERGE docs to mention that ONLY is supported.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 5defdef8aa0535b8e9365ea9cceee60d5731395f
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2022-12-09T10:00:01Z
Releases: 16.0 
Update MERGE docs to mention that ONLY is supported.

Commit 7103ebb7aa added support for MERGE, which included support for
inheritance hierarchies, but didn't document the fact that ONLY could
be specified before the source and/or target tables to exclude tables
inheriting from the tables specified.

Update merge.sgml to mention this, and while at it, add some
regression tests to cover it.

Dean Rasheed, reviewed by Nathan Bossart.

Backpatch to 15, where MERGE was added.

Discussion: https://postgr.es/m/CAEZATCU0XM-bJCvpJuVRU3UYNRqEBS6g4-zH%3Dj9Ye0caX8F6uQ%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/ref/merge.sgml modified +16 −3
src/test/regress/expected/merge.out modified +65 −1
src/test/regress/sql/merge.sql modified +34 −0

Documentation touched

Discussion