pgsql: Don't allow composite type to be member of itself via multirange

Don't allow composite type to be member of itself via multirange

CheckAttributeType() checks that a composite type is not made a member
of itself with ALTER TABLE ADD COLUMN or ALTER TYPE ADD ATTRIBUTE,
even indirectly via a domain, array, another composite type or a range
type. But it missed checking for multiranges. That was a simple
oversight when multiranges were added.

Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/93ce56cd-02a6-4db1-8224-c8999372facc@iki.fi
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/34ebeb15c8b18330d992bc672c1192b0d9436fc7

Modified Files
--------------
src/backend/catalog/heap.c | 10 ++++++++++
src/test/regress/expected/multirangetypes.out | 3 +++
src/test/regress/sql/multirangetypes.sql | 3 +++
3 files changed, 16 insertions(+)