BUG #15833: defining a comment on a domain constraint fails with wrong OID
The Post Office <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: clemens@ladisch.de
Date: 2019-06-05T10:50:35Z
Lists: pgsql-bugs
The following bug has been logged on the website: Bug reference: 15833 Logged by: Clemens Ladisch Email address: clemens@ladisch.de PostgreSQL version: 10.8 Operating system: Windows 64-bit Description: postgres=> CREATE DOMAIN ddd AS text CONSTRAINT ccc CHECK (TRUE); CREATE DOMAIN postgres=> COMMENT ON CONSTRAINT ccc ON DOMAIN ddd IS 'test'; ERROR: 42704: type with OID 444275 does not exist LOCATION: pg_type_ownercheck, aclchk.c:4585 And there is indeed no type with that OID: postgres=> SELECT 'type', oid FROM pg_type WHERE typname = 'ddd' UNION ALL SELECT 'constraint', oid FROM pg_constraint WHERE conname = 'ccc'; ?column? | oid ------------+-------- type | 444274 constraint | 444275 (2 rows) Same with Postgres 9.6 on SQLFiddle: <http://www.sqlfiddle.com/#!17/a63b6/2>
Commits
-
Fix handling of COMMENT for domain constraints
- 13f4b462dbe8 9.5.18 landed
- ff1a25601e75 9.6.14 landed
- 56a932533aa2 10.9 landed
- fa5f3a4bcca7 11.4 landed
- ceac4505d342 12.0 landed