Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Date: 2025-04-07 19:52:06
Message-ID: 202504071952.go6yqgqosl7o@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 2025-Apr-07, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > I have pushed this after some small additional changes.
>
> Looks like some of the test cases have issues with locale-dependent
> ordering.
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jay&dt=2025-04-07%2017%3A56%3A49

On 2025-Apr-07, Andres Freund wrote:

> Looks like the test results aren't quite stable across collations:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jay&dt=2025-04-07%2017%3A56%3A49
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hippopotamus&dt=2025-04-07%2018%3A28%3A12

Should be fixed now, thanks.

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2025-04-07 19:54:38 pgsql: Fix some issues in contrib/spi/refint.c.
Previous Message Andres Freund 2025-04-07 19:24:42 pgsql: localbuf: Add Valgrind buffer access instrumentation

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2025-04-07 19:54:28 [Question: linux pipes ( ... | gzip | cat ... ) in tests failing] Re: [PATCH] Adding pg_dump flag for parallel export to pipes
Previous Message Tomas Vondra 2025-04-07 19:51:17 Re: Draft for basic NUMA observability