BUG #15833: defining a comment on a domain constraint fails with wrong OID

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15833: defining a comment on a domain constraint fails with wrong OID
Дата
Msg-id 15833-808e11904835d26f@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15833: defining a comment on a domain constraint fails withwrong OID  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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>


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Juan José Santamaría Flecha
Дата:
Сообщение: Re: BUG #15789: libpq compilation with OpenSSL 1.1.1b fails onWindows with Visual Studio 2017
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15834: Cannot install npgsql driver