Horton

Update MERGE docs to mention that ONLY is supported.

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

View on postgr.es
Commit: ee1c6728d8a9c377287577e34444442fa3ed16eb
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2022-12-09T10:03:04Z
Releases: 15.2 
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