PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15833
PG Version10.8
OSWindows 64-bit
Opened2019-06-05 10:50:35+00
Reported byClemens Ladisch
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15833
Logged by:          Clemens Ladisch
Email address:      (redacted)
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>

Messages

DateAuthorSubject
2019-06-05 10:50:35+00PG Bug reporting formBUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-05 18:15:02+00Alvaro HerreraRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-07 05:42:33+00Michael PaquierRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-10 06:28:55+00Michael PaquierRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-10 10:25:57+00Daniel GustafssonRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-10 12:55:27+00Alvaro HerreraRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-11 04:55:39+00Michael PaquierRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-11 13:32:55+00Alvaro HerreraRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-12 02:36:56+00Michael PaquierRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-12 04:51:52+00Alvaro HerreraRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID
2019-06-12 05:40:24+00Daniel GustafssonRe: BUG #15833: defining a comment on a domain constraint fails with wrong OID