Summary:
Enable support for ALTER TYPE ... SET SCHEMA. This is required for orafce's extension upgrade
(to version 4.9) that will be done as part of the YB major version upgrade from 2024.2 to 2025.1.
Specifically, the command is required to execute the extension upgrade script orafce--3.21--3.22.sql.
Jira: DB-15561

Test Plan:
./yb_build.sh release --java-test 'org.yb.pgsql.TestPgRegressPgTable'
./yb_build.sh release --java-test 'org.yb.pgsql.TestPgRegressTypesUDT'

Reviewers: telgersma, hsunder

Reviewed By: hsunder

Subscribers: jason, yql

Differential Revision: https://phorge.dev.yugabyte.com/D42213