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 ) id 1tVaxo-009qVc-Lg for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 18:39:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tVaxn-004Y7V-K3 for pgsql-general@arkaria.postgresql.org; Wed, 08 Jan 2025 18:39:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tVaxn-004Y7N-69 for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 18:39:30 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tVaxk-000Yxr-0N for pgsql-general@lists.postgresql.org; Wed, 08 Jan 2025 18:39:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1736361566; x=1736966366; i=shammat@gmx.net; bh=irwLWO6/LTZQHW2UKaODSDYI4EaLfBJ8UG/dPFujfFE=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=S0U/GtM3CkOGWIjCVd1sayBBb/pS5f/lOn1FikDvfNS23Szeji/KHFgihdaOlM3J UJ1p+GUannqluIpfAr9rhOQODLH7sAExTvMVmCIr5ed2FWSq6FnQ+2ZgnY6fwv3By f355sin0F8WhhLtvP4jSG0oiIpS2Wuzw4L/DEimb/vN1y91LcvBGjOnnPH56LINd/ o8KDSC/ad8UIaseiyeQZFDaqEJLRlM/8yZuzYSFPTAJsYTLriMwax4u0Y0eHx0jI9 TyVGpNcczMNLm/fXJUWeUgXHF+RK6zV7xMxMgXIcsXeM5Q0ww/8vg8IJjZVoI+6ne ELTcgNTMLQn5fINoWw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.31] ([88.217.180.159]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MI5UN-1tH4Ek3yxL-0029TV for ; Wed, 08 Jan 2025 19:39:25 +0100 Message-ID: <46650e9e-beb3-46ad-a26a-b356d6476cd2@gmx.net> Date: Wed, 8 Jan 2025 19:39:25 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Postgres 17 domains with NOT NULL and pg_get_constraintdef() To: pgsql-general@lists.postgresql.org References: <202501081310.k4vpnx4wa623@alvherre.pgsql> Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: <202501081310.k4vpnx4wa623@alvherre.pgsql> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:SJ82QmQO2+bfJA942Wk/CAjsQHhEw4+g9nf4dtd+jcJcocOyW8l yYBl2bA26r78jl5qFsSWOs0+IrYPKjYNhuzkGMhGRmhKfRn+R0dMRi/rucwbAZYXbBVqCwZ 7dgrO5RAP2XXLnrUGcQrEBAMqWXaM9lDJ3ulhh5MXY2ODDcxojTyfBKmYg2ZMAlNFbJLio4 FEjaqrLVJB4c0uR+f46YA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:OiW0M561M1A=;sS08qWyi/M76Oo9HeS3jTcssk2U Lc6hevCqoEKvA57CKQi9Cxu09Ilj3EYZL6U6Mf4Ub7w2z9tcaRSHELS5lD3E4EhKuZ01b9+42 Auyd1WYJGjBTQFPpQdouEovRQcKlF3AYczXa76V6LGSelwrxtn7JA3aymC+sK/Pq1whqZ8ptq dEZ8/nK/m7vRGKS+uFgveW6RNDrL7c3oQAZ1HFJTuIrVgCN6SQXY4WSl6HzZWcm7cTlDovm+6 a1Zg0HS0AOu9M0Vuo7t53ZU6RQR7v4ZdewOxKoN843K7Kq3e0njq81hw+owF9j5uwV3O5C1EA J331qApgqXhFqGSRQLeOlYto8RjWyhEY4RgsHvv6sCM4dHrrFbTbi0LS2m3S/WmEdecPqCgpN 7Gjee7TxZgSkX8atlkPOQP7OJWQqM/0x8avlJSK+orz9NYGA/vj+jUr2yktZfarzTedbyk7P9 ApRbE3Mhp5nv58GiU+qOC29qZlUwEnJ2jxtwWeSnUFjMr9SNAz6EOoBm9tvsNdU+ZiKOvpdCm IpmoGW3rG6oZZIflWxERgiE5JMmQeU+0dTYlj8hmrTIF5YvYMzpxXoKDGYOJ36kEj2CIYGPr3 6/Kisuse/Gike8UI2blzPvRxvrNPwBWHxZI4x5B5Y6Taxv84Zged2dDKfcKBZBpn03n7U1Zmn dfidqFYMHRoHsBd9cxLOauNd0d+72n/7F/1xKc2tAMGfo1sFJgrQzvNIL3O6IRKVkPrIgBzd6 Vu9X9n3ZrV11bg3CShSfl0glZFgrvcwHzag8Ous/F5hQaAgoDipPBv5ssgl9fWRIjD94DSTlf iaEB06aZjoWSpgMSJ7tx2MK3UgRCzUOmXVd75SgUkRIH2vL8OfyasUvi6WTwKLMMUjYtX1dUz nVFYb+JZ8Bhiy4xxpU56OWrHrzYLt1mg6/iYTQU7fTCLYf3XGD1r/dqtv3h1Q0Vwa5exIxRzz ihoCeSfhqhAGhLZeUE2g4rjEJrpnImzC2nygBW5DeWsriRTHzWJ2yR+xIIJOaCKdJDgV9RrZ2 c7Lj+dx7rn8JiaGsGVtdAG2qOdvV/jSzmv0haqfNErMTROItvjS5kf+kqq+vc/cpqoZWDfClS rc37CYm0gEOpayO/8SxLv7e1zljbWC List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 08.01.25 um 14:10 schrieb Alvaro Herrera: >> However, because the domain is defined with NOT NULL, this fails with >> >>> ERROR: invalid constraint type "n" >> >> with 17.2 on Windows and Linux. >> >> This is a result of storing the NOT NULL constraint in pg_constraint >> and can easily be avoided by either using contype <> 'n' or by not call= ing >> pg_get_constraintdef if contype =3D 'n' > > Yeah, thanks for the report -- this is clearly a bug and it was fixed > already in the 17 branch, but it's not been released yet. It'll be in > the February release. Thanks for the confirmation.