Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uMoPD-004OxY-Q8
	for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 13:43:47 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uMoPB-00CaFp-TN
	for pgsql-general@arkaria.postgresql.org; Wed, 04 Jun 2025 13:43:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ddevienne@gmail.com>)
	id 1uMoPB-00CaFg-IL
	for pgsql-general@lists.postgresql.org; Wed, 04 Jun 2025 13:43:46 +0000
Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <ddevienne@gmail.com>)
	id 1uMoPA-000BVa-1S
	for pgsql-general@postgresql.org;
	Wed, 04 Jun 2025 13:43:45 +0000
Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-2cc36b39545so617317fac.1
        for <pgsql-general@postgresql.org>; Wed, 04 Jun 2025 06:43:43 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1749044622; x=1749649422; darn=postgresql.org;
        h=content-transfer-encoding:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=qyRFIdnbida+AgZ7PQUn+a98dbT84CFBDjSwzC6qIO4=;
        b=GAYNcZKJZTHYmv4noAYAXZHcq8fV37alMeN6Q3n+NSHicc9rq1kUlxXhb9IO1tVivG
         lsUnv3uP74VUagGbfdhDp5125pEfiwCDYZ5Nfz0pesmnNcNofItnX8YTaWoNG3KWi4+X
         zYTsF5AuRxtIGKZWngcLNTAYvlQ2d4c6WHVizlohc7fBeJWFQSkFYdVmeYeakZ50GvLx
         9JuaPHYMoWmFVhvtDXY6C8JvFEeFTg0NLtvVG+gETPPT9GTho7ZPxUc3updjzfOd+UA5
         Ju2OrT2g/Z5efYhDUYWg1qwgwzapOE/h06czPxFIUYEydffydPRji45NChUJg0FaEYkf
         59pA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1749044622; x=1749649422;
        h=content-transfer-encoding:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=qyRFIdnbida+AgZ7PQUn+a98dbT84CFBDjSwzC6qIO4=;
        b=UbxL5aWE5OtxsM2p1LSI1mK2l/HLRItlzKPiVOOx2VLfxqIlQ9qyIFBcZCPvC/md4g
         KU8iffTp1V9j71bsCMpBA6a7F8vmA8dxY+vhBSNwAEq1I2tN+A6895UI8S8hNGXAHB17
         lXbOUndPUsCHsVucMwBXgESZioB5pZLGsCl2tHrI48LnVz9fI/UNMuieOYbGe0wfmZJo
         YmiLpY/iOcr/thkCSF8QUovWNLlpqOspRLNKjoKn3z3U/oOkifGHhkPkfetVo4JH4BKU
         ld+nCeRnn8WQl4Wt4OdunEfGBWoAU/gOiAMrruwpLxSdKcbVwR56zZ/m7HfDyw9KUci4
         XRDA==
X-Gm-Message-State: AOJu0YxPxOlcdlYRFnmq38sywXvceuns0L6z58T8BsIHK4PFUAJIBYu4
	iVkKqjKHFXC1GwGaPVAsCb5uGZ62G1tw8zGeHWzntKZ6rKrmcn0FMZTfohfa9fyqoG4SCkfMGto
	xCa3TiIIKtNverwlW+l/17bBYZGNqYKgQvCWn
X-Gm-Gg: ASbGncvGts9xgi5EtdU1EiQ0pBceEmjf2hY2Ur5blXJdCfA2s1puCCaPUEHvLeBUMgj
	fMt9Av5fP2+tVNqu63yvA0BvR/07dDv2YIjtgcM8UIxE4Ilb+vm95f9dqNaT4HnsDiPqyLBtAH7
	tv5J6fNyuDHd773lMunhECC3Fqf9Bygn3ESSdEvFltfm5xpA==
X-Google-Smtp-Source: AGHT+IH305wlP/twUlQRy49ib3170/Ikf7dav5ki89SYNmxLS0Oqy5/OurieDTxf3umXfKHJpprqzspPKWjGRPkyWjw=
X-Received: by 2002:a05:6870:72d2:b0:2c1:539a:6071 with SMTP id
 586e51a60fabf-2e9bdc7eb87mr2020402fac.10.1749044621913; Wed, 04 Jun 2025
 06:43:41 -0700 (PDT)
MIME-Version: 1.0
References: <CAFCRh--+c38Qfp_i4SOt65PKuKcZLZAtS+1P=6BjMAnoNHisGw@mail.gmail.com>
In-Reply-To: <CAFCRh--+c38Qfp_i4SOt65PKuKcZLZAtS+1P=6BjMAnoNHisGw@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Wed, 4 Jun 2025 15:43:30 +0200
X-Gm-Features: AX0GCFve02jyra-nlETo1Lt-m5HrCcjrOsnTcwDYIKnImK35iUaKU9XXP_2Eab8
Message-ID: <CAFCRh--hgwsVFz6f3HTWDde=h2gjW6MrnFJFAbNEOGkm5vqDqQ@mail.gmail.com>
Subject: Re: pg_constraint catalog changes in v18 beta1???
To: pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--hgwsVFz6f3HTWDde%3Dh2gjW6MrnFJFAbNEOGkm5vqDqQ%40mail.gmail.com>
Precedence: bulk

On Wed, Jun 4, 2025 at 3:07=E2=80=AFPM Dominique Devienne <ddevienne@gmail.=
com> wrote:
> Is this change of behavior normal?
> ... Was this intentional?

Well, apparently it is intentional, I found an entry in the release notes.
Case closed I guess. I adapted our introspection. Thanks, --DD

From https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-CONSTRAI=
NTS:
Store column NOT NULL specifications in pg_constraint (=C3=81lvaro Herrera,
Bernd Helmle) =C2=A7
This allows names to be specified for NOT NULL constraint. This also
adds NOT NULL constraints to foreign tables and NOT NULL inheritance
control to local tables.