Re: Catalog domain not-null constraints

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Catalog domain not-null constraints
Дата
Msg-id 6072822c-3384-4455-ba0e-121acdd5bf7b@eisentraut.org
обсуждение исходный текст
Ответ на Re: Catalog domain not-null constraints  (vignesh C <vignesh21@gmail.com>)
Ответы Re: Catalog domain not-null constraints  (Peter Eisentraut <peter@eisentraut.org>)
Список pgsql-hackers
On 17.01.24 13:15, vignesh C wrote:
> One of the test has failed in CFBot at [1] with:
> diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/domain.out
> /tmp/cirrus-ci-build/src/test/regress/results/domain.out
> --- /tmp/cirrus-ci-build/src/test/regress/expected/domain.out
> 2024-01-14 15:40:01.793434601 +0000
> +++ /tmp/cirrus-ci-build/src/test/regress/results/domain.out
> 2024-01-14 15:42:23.013332625 +0000
> @@ -1271,11 +1271,4 @@
>               FROM information_schema.domain_constraints
>               WHERE domain_name IN ('con', 'dom', 'pos_int', 'things'))
>     ORDER BY constraint_name;
> - constraint_catalog | constraint_schema | constraint_name  |   check_clause
> ---------------------+-------------------+------------------+-------------------
> - regression         | public            | con_check        | (VALUE > 0)
> - regression         | public            | meow             | (VALUE < 11)
> - regression         | public            | pos_int_check    | (VALUE > 0)
> - regression         | public            | pos_int_not_null | VALUE IS NOT NULL
> -(4 rows)
> -
> +ERROR:  could not open relation with OID 36379
> 
> [1] - https://cirrus-ci.com/task/4536440638406656
> [2] - https://api.cirrus-ci.com/v1/artifact/task/4536440638406656/log/src/test/regress/regression.diffs

Interesting.  I couldn't reproduce this locally, even across different 
operating systems.  The cfbot failures appear to be sporadic, but also 
happening across multiple systems, so it's clearly not just a local 
environment failure.  Can anyone else perhaps reproduce this locally?




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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Reduce useless changes before reassembly during logical replication
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: [17] CREATE SUBSCRIPTION ... SERVER