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 1uSrW1-00E02E-Cn for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Jun 2025 06:15:49 +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 1uSrVy-00679I-FP for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Jun 2025 06:15:47 +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 ) id 1uSiSe-004GcU-50 for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 20:35:44 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uSiSc-003Cpo-1M for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 20:35:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1750451741; x=1751056541; i=grosser.meister.morti@gmx.net; bh=TKWhJxEm13yjV93KsFRbk0XFNMFHFPG8/lgGLzQ1fk8=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To:Cc: 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=Q3A1tpovHvuKHtldviaxZn6rwz37GfFm3+GGZU0TowINETA2IN/a/pUtFppULy8R 9MLYIPpm1LXAeAs22SALVYcEnxRgOgDsWI/wFd5Lbhgh3H9PKFa35B0UXIbL2kGoE 0T+8cexTmKkEESaY6D30h88AuF7LjAfO2MvyFg7jla5/3V1UUSSUfjaIMEgikqg8c qZCyeXZE+PkwI/WQC4LixI2VjkxydsaRDmqUoOB+42i2ZpQ2acsJE4v39SQ7tJhdW kJEDhA2CPii5BkAFUGz8QXh5uhgZBvfUhWyrCD8YcQb4elzdXtjkwEypt0XsxHdu4 VxHoENhKWBuJaRqZ8w== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.39] ([194.96.117.109]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MHGCo-1uXARZ2B0K-00G1fX; Fri, 20 Jun 2025 22:35:41 +0200 Message-ID: <94185454-0d6f-489b-9dbe-65ddd81a3c48@gmx.net> Date: Fri, 20 Jun 2025 22:35:40 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #18963: Column confupdsetcols missing in pg_catalog.pg_constraint To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org References: <18963-4fa37be61361c1d6@postgresql.org> <1939224.1750432499@sss.pgh.pa.us> Content-Language: en-US From: =?UTF-8?Q?Mathias_Panzenb=C3=B6ck?= In-Reply-To: <1939224.1750432499@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:qV/Bo6k6jArEtBOVxQMgFOs8cmZmltLVrLhHIsXnPL65AWP0eET bbItRZPnx8/70RRixLh0orJRCUYega+ikxpkRZxuhVQmg16aOhKF2MuPCDEGuwO37paXZ+n mNEIsExy21NE2qBsOoH7jhTZ9gJBj4RLekRQ87rpxGwWVpx0hJA4psyYK494dnE9/UgmYpa 5KnvnbVrcRFpvcBv23j0g== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:Zri4itHEqBA=;Qkp0ZrFPAjVa/tVMBSIfI7ZFWS7 p8hpobG5DxFe4TeSjODoVdC40sNZlzu72tkViHuPd+49Aq9H9PxzRqD9k+gVuMh2NUx858Qc9 UCiY5jTTMWJIWxdqCoiplDrYRxgXCKrPliyptK/4F4P7fF8hOrYobUKPj6GuJt3CA1S7xbCJw lvRg+ne1BCOAigiZubRIDPIeHFp2vGihNFqoy59aLGY9ZnMvtphPYD0Ws44yI2T6WDvVczWB4 DJsUuzVfmZr4ykRCLKeSj8ttMnrNfpM1JWh+dSU5hSHjUJlJ19CwKQAIpeJf+K2r6SeOh0BZB lxEUtsQwJ29hO2vE9izrylJGUvcvDWPW4ldgWUZlBtvim2bIx6EWrqB2/CfMJUYvb/dYi5+V3 PDt/OAgtySwsl5Z/D4NtMdJPhbsfjT36i9SL59iNhvQPsA/pd0Jikn4CwqMsui97zug0PEvxh XESzdc1yzIlbdLQc9Xi3AT1YC0EwuyGHJEeclfNq+CsL8RSEQ1ny/Sml7yX2wKgTwxWjJH8kZ zT/kCE4DOXfoxRpsMAyg8Z/nEKSrvHqBcLPeJinhDfc4xx7ELjQmXkCSSjye+59RwPGkhZYUP yZOlpEiQ2iiqp68mXKUpGssYyQgxHwUYSE2KKQ8X3lE1vwlyagQZuKiABDIH8FAkHCgkEbzNJ l6d9dCWPBktqwkSua2BMXei6ne7rrBh9FyTYRvpggn+cdpQhZLNR+chyTWy4lTUJFaLfl3GAj qoEY/fLv9e1IeQDAky7DzI8i3CwHMs5yLODRJNZtSeRVQhChcuWxiRvz7yGvKStCUoEHu4M34 PWw/6VZE8ZDUhoK+UGzb4RiRvATWNhy4nx3ToNEcLNRkr6Y8EzP0fZqamPZT5uw0naxRtNFPv 6b/x50xhZefzJK6MrlxXlFHVYauZJf67f9HwgeLbZsLUP3glur4kbT/Ry2GyfCU+Akt9swQ2x YBdnu8ZYEe42vshb69RbManZFZ6i7DjOsHDdNAMmadAv+xIeofqIJ/IysivsxPcxBdEJXnkrY QYaH4OcKWyX3y6Y/szpqcE1wQOV+WpQwUyb42BBZH62A568PplQ8SaotCdyx06HEh+tpMasOx RGyP66SeGNBhv3xUhJxqb4qvJhzlGHKv++1FZq4UEkVB6ouz2gNdbiDUHdevB//+feB+TJQVf rffYEv5aFSAbKkuislwm/E/THPdrtlVM5aRtT3i2VLuHwErmw8xJ2zuJ6E4QCiwzAmkGcM8hL tcUSkC0M3wOYhte03M7bBeUn4zsI/FpRXqoAcNDP/ad0pzxFdnFqKj+X9V4vji1a6AIF/Rbr6 T7BZXzE7i9t8SRkyxzuKV9Bx56En5WTt9oS6SMUcyw4JPmzQcHtDn888t8OuYnvMrZieErg7W cQZxlofNwXQoee4oeM8hP8EYYyeaiGH5q6OPK8h29Ln5q+r7BW27W0DWAelmHmsaNtwzgkaQT UYCdTyj5TBwAJlY1/I1T9pnyC8LE/+ZhqNHoaGI+UlKt5xgIOWdk5Z55iibOvAe9/HBr0ZBG7 lGxXIgVolemZGOedacE9zapUqTp9IQT8EPpDBtKFihC2U3XEN4tTZWVNZiego4ZQHI7+1otT5 n4H7PU6GOW4oQxv78Q5iKQJIjwOzaJY854AdUtOWiV/NBKu4r7x57rujOWXCEqp9SqrYoPIoP Rq9GCbNnX81benQ81dCNQxSZ4dqRHPexpYoxYjy71D61f4TkjDZFWZexrKcKgT84xFTpoYNWL 8+pTbe6gc67QjLNIZ4cB7UvMqq3xPPeMo0ONRX7gvFsvP2HQSVSQ+U1MrmvVI26lq1+SKggJu /zKmTibxEk6cYwH2rD0EfeG4S446/NZ4/RCnCR6lOdcM9q58GO3EErTt9GUAwKcAAPS1UkIvA 7Wjj5qshJWKDJEC2Mb8eb2fWuEkR7xKxWkCALDqL2pZPQ7eMP4CE8THXDm8PI2ZsJgtlJLQ2x 5KsfVy78tE4j0WRhAfKKfDrb2yZBZLIzFrGIBMSw/JuEGzgWTX9NqqYNfuplwjEDhMk8mJvn3 MZq5y7kj1kdf37irJ3CERUpjoUQN7KCDqh/sVBEPWGkscgVoNGRIHDPIlr9drnnDsoJtTHDJG f1xdNy3t0KIU03TZvA2pL5rrYOhxuhcBbp3l36bnwvtz+7YZWn4MCidx1thvloKQVBhk3FLj+ 8T/9VfEHCXF7DI0gEvSiRa9ykDBLH9rZmmGOg/wQgv8y4uqeYNl1KoPBhDssFDePvsPjnw9A1 E7BD3GLxV51kbuJ5n0N6c4aO8v/tXSztRkZ4N7/Kxw6Gzud3liYMefQtTGDXbf5vAtXJi8yZs dRCRErKiUx3jhb6KhNcpQL7RryGs2a+5sUqw6GTqB+Wr29lHEIIZnNan+UL42vELMqu6RpvC0 vbzV/ybZ2jv+yYXj/kol8Y/BtxiTqyEYVZhzxqZw7gt4QJxTPxJ9WACKU2BhTiOTgdmKcH5ln tkMLh6TqTmYBOQxRn+kJqysEGiX/m7Wqp0oa0PcOaF111qc49bPqrf6EjSEx1aysr6XNUNgk+ tfmaiHlBxJulvOl+0o4AzDuUbz9WOh8Edl8Xm+17qQrVi5zfa/P+GcME63pgv2Yk2yyXGNE68 MapuWaaVo+G3z+zhoPL42XvevCNtBuKj/2hC3xb0gKmrACA9PBCuzpomNuOwo2SYfIMbgygVI ESmm88IxXSv/kR0rShV/vMpSwNoJzwRXpmhxqaiQX+PPV7UDlK0KX9F+KPVu+uKrbUWJXw9m3 Mc4uAXecxoMEGAc8bZuhdplAI3z49kB9irP7qgnJQJ+UP4tKkLAhDqwmSkNBHWaAmcK3NJ8WK 13PMg/6GfZh8GtEUuPEg1HCaCcPWLTDQDN6jpo9W4Muzt9cxIQZ9Axg678uynkm1NXg9ivp+R ChIVmrFlrsknJNf2pKxYM3yZXcdMit5LK2HcPImT7/NVmlit+P8XqfBUIfXK5Qys2B2+yXhfB ROmUUMNh1XZnDwudNKWZ0XBLcZP55taFQtgpPDhu+Vj71vFEsyQymuf6qawddWU3/IKqLbHZm qG00CCR3VAqGGR1eFUBmFgPKvZ+wzkxnyXPL5YodhuM84n54hkLws3dbO7+SdYCF1ZQMJhDWo s0s1NLCffpyTsBFADXWUEbmDfCuWKFGaNM7z31VN3n/mT3Q2yeDCAkEkbBTP8SnK/33RDbyZm WlNv2M174wsFoAs4T+32WAV7bq+3nnBIGQ187dQMQeBXkrwIcfqTob+Ijb4Ff41LKzWHTinqD nEOk4x/9oH4HQZJp List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 20.06.25 um 17:14 schrieb Tom Lane: > PG Bug reporting form writes: >> Foreign key constraints have the option to list the columns that should= be >> changed in ON DELETE/ON UPDATE SET NULL/SET DEFAULT. For the ON DELETE = case >> these columns can be inspected with pg_catalog.pg_constraint.confdelset= cols, >> but there is no such column for the ON UPDATE case. Is this an oversigh= t? >=20 > It's intentional, see here: >=20 > https://www.postgresql.org/message-id/flat/85f8fcae-5a85-0d81-ae72-12c8a= 5cb271e%40enterprisedb.com#b7a607d6496828fd21caf2b6bd2b0f07 >=20 > regards, tom lane I see. Thank you!