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.96) (envelope-from ) id 1wC9mW-001iRw-1s for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 05:24:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wC9mU-004u44-2c for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 05:24:19 +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.96) (envelope-from ) id 1wC9mU-004u3v-1G for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 05:24:19 +0000 Received: from mail-qv1-xf2f.google.com ([2607:f8b0:4864:20::f2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wC9mT-00000000kLY-0hdG for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 05:24:18 +0000 Received: by mail-qv1-xf2f.google.com with SMTP id 6a1803df08f44-89f87257904so33024096d6.1 for ; Sun, 12 Apr 2026 22:24:17 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776057857; cv=none; d=google.com; s=arc-20240605; b=cuyjhJX2EiVZT+mkTI4pk9z1al8z1379lwBIExYyMaSZSVLYqbJVP0pUTkUbQpkxf4 FgPYmDm1YsRzBtXy2m7+y4ehs1rlqOzkLM0uS0YyYbvZn7vHPN8Mjt3ByhVNuwdrmmS8 WrwKxeLilDdQj7VnM/kvXW1YQ0yiVL5C8Xp945kGjk8rlIAe1iZwnviiiBrfhotCxONP htvcHB3asST6qS4d7mWmwyrPdT9cUvq+Q8pu2Mp3Kj2Vc8/QyGxuSXE+Vizpo2P9QJFY LhwI9chpBMHDjaqCzx5aDky8xrD3L//XwiQXz5pDbeB/plemlNT+9WslsdYOQUyAOEbq xqJQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=+Pwm9HFSpZ+WgOKCEF/5ss4sLzZk3B4zGdoNbRl/u6U=; fh=G/S7H4ZcLBlMd9SxkE/UslylrDmjgYbwyCXCt+QldOE=; b=bgMkLPKe2cTGgxqAKnUyaXIo5y80u+/XC6ojPoo8q+jo7sEvdh6/6aqKH0piF6/6R5 sUTZQcH353sTZSlKR7akiyOzf/tmeepSI4oV4su0gxzACiE1AG70RQg5ThxzxKp6vGGw uNXl6uPgycgouxPWqmmqOIAyokmAOhC1FvWh0QCoXT+0XkuFGfILwLlmBwHQpA7VGua6 H4/DUvT/uQAK7FEaWH3YHy/EOFJ+PJsTtN+aFpVb8sJXJXyDy5d5ZdR7tiRq0KBg8O4O o0cLrWiXwRJl/LxyVTvxZhScenPMKrPCj++R5X1WoXFtEL3BS+nlhZlWK79D2EuM/5lS Lu/g==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776057857; x=1776662657; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+Pwm9HFSpZ+WgOKCEF/5ss4sLzZk3B4zGdoNbRl/u6U=; b=QuvgdJ+gqPYfuycC1FvbpVL6UPqJOTgWVAZjBpMqt6VlqLLBUIlKCAluqZWAmy+5hP 3W1X4SZkLlGPp5ZSzFHoPCzwW3UaG2NIIiFJSdZHcKWYahEu5N2+kMM1zyFfrQkLFX5R pA+QdyghwGnp6PXuXjl1wUNLs2SkBE6oF07C8T7lFFfM/yC1FIE6FFZDc1wT9aGfMP21 X0WxsB5tjg3E4qZVjfUhmDU+SOJdAGXFpS3VncR20aEbbJ8tBmzL+NCFraemCM9MNp4C oi6LHrv7XXO7RGFnbhOZhIs+gWCSSIlD3+U3mNiBxaXnzo6/mNAEEVBWCBgT+K8aNDFO PRlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776057857; x=1776662657; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=+Pwm9HFSpZ+WgOKCEF/5ss4sLzZk3B4zGdoNbRl/u6U=; b=HrUUjBRNMQIQmJS2I7wjakz4cMR+mNP9WD1PVDwWpccdxGiSlZ8Qbw1q+uNkTU9x6m xoub6cLYhRi1qMvvIKED/nP1CzLUgGtkQ/EJ+C2Tc4CxxJClfI1e1awGoiUm4O9QnbBo yHheFq4J0EaTI0oZn6LudCEr2dGAeNcXPTMZIxIQUDMUNV5WvW6drQ2gwBcVuNSLyfEt uWRjVeLwTxf3ywnlr7f1G624Jq1XokIefyws9qswUmA6KV3ko1MbIEuVW6D2Vc10ZFqq jo9Bi7is5DXTUPkDdjLsSViDjv7LZVjfbkL/3Ts3MYcXQFj7a2Rk5GGcZgB/5XXCSU+t s3xQ== X-Forwarded-Encrypted: i=1; AFNElJ8TNPBpBgjKUu3aOi+S42b9I9H/liTBFAOCWX05siAiTKMYYhEepJktnDmXdiaPic8YIXAHociqstFKyxI3@lists.postgresql.org X-Gm-Message-State: AOJu0YzFlUcMalkyFifxV2D28WJkwCNv5QAV97YsE8GXVEHdB4T8KT4Y PZlCDg6DxE4DstQS+7IqrlrS0qLWAaCYUEWlP5J27FWYnFv07ZtlM60tD83NQKXS07ww3NHpqcB RHVdCIpdElPgfYoE8MtNSUsYKp6Z7H8c= X-Gm-Gg: AeBDiesZPJmoqBJ8CDupn2ioYMR68z+5PvAsBpFKEQjRKefm70fp0CUHJ1XZ0fEa7aX 5q6tK4+v3QuTcBEByRjgrWoE1Q7RrHOZXFPeOQZUPFIYZN9NoahWutfzUth98fX6XGXO4fdi/7S jHUMqfQkDcTe2zBh0zZmp66qVfbF+ZNtAney3/BhB3djZIXGrShqt+R4T97z7I3lezlebE+XePZ HMnFgbi1Su8gAzk4DjMRioU8NA6r4w1nSYwKu9vAiJ4VVRX/nUFCCOw9KE65BUKPOUnezUA1INX erTJZw0= X-Received: by 2002:a05:6214:401c:b0:899:ff74:5974 with SMTP id 6a1803df08f44-8ac861c2145mr187507376d6.21.1776057856778; Sun, 12 Apr 2026 22:24:16 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Smith Date: Mon, 13 Apr 2026 15:23:48 +1000 X-Gm-Features: AQROBzANkkpI-t5CrywHtD0oLj6ZVvK5xUzP1d1_HuKk-QOG4xYpQNLBf1u2G20 Message-ID: Subject: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+ To: vignesh C Cc: Amit Kapila , PostgreSQL Hackers Content-Type: multipart/mixed; boundary="000000000000a7acfc064f50b1c5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a7acfc064f50b1c5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Apr 13, 2026 at 1:21=E2=80=AFPM vignesh C wro= te: > ... > The commit message could be improved: > Date: Mon, 13 Apr 2026 12:12:00 +1000 > Subject: [PATCH v1] describe table except publications > > --- > src/bin/psql/describe.c | 2 +- > > Other than that, the patch looks good to me. > Hi Vignesh. Thanks for the review. PSA patch v2. It is the same as v1, but with an improved commit message, =3D=3D=3D=3D=3D=3D Kind Regards, Peter Smith. Fujitsu Australia --000000000000a7acfc064f50b1c5 Content-Type: application/octet-stream; name="v2-0001-describe-table-except-publications.patch" Content-Disposition: attachment; filename="v2-0001-describe-table-except-publications.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mnwqyp5d0 RnJvbSA1YThhNjQ5ZDJlYjY3MzQ2MGJjZTg2YTgwZDBmZjYzYTRjN2ZjZmM2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBTbWl0aCA8cGV0ZXIuYi5zbWl0aEBmdWppdHN1LmNv bT4KRGF0ZTogTW9uLCAxMyBBcHIgMjAyNiAxNDo1NjozMSArMTAwMApTdWJqZWN0OiBbUEFUQ0gg djJdIGRlc2NyaWJlIHRhYmxlIGV4Y2VwdCBwdWJsaWNhdGlvbnMKCkNvbW1pdCBmZDM2NjA2IGlu dHJvZHVjZWQgYSBzbWFsbCAiY2FzZSIgaW5jb25zaXN0ZW5jeSBpbiB0aGUgcHNxbCB0YWJsZQpk ZXNjcmliZSAoXGQpIGNvbW1hbmQgb3V0cHV0LiAiRXhjZXB0IFB1YmxpY2F0aW9uczoiIHNob3Vs ZCBzYXkgIkV4Y2VwdApwdWJsaWNhdGlvbnM6Ii4KCkF1dGhvcjogUGV0ZXIgU21pdGggPHNtaXRo cGIyMjUwQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IHZpZ25lc2ggQyA8dmlnbmVzaDIxQGdtYWls LmNvbT4KCkRpc2N1c3Npb246IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQv Q0FIdXQlMkJQdnRtTTd0Q3V0LUstRVdTcTBfSGc1ZXklM0RNMk5yZVVfRnE4MFNwVU9nbWlCdyU0 MG1haWwuZ21haWwuY29tCi0tLQogc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMgICAgICAgICAgICAg ICAgICAgfCAyICstCiBzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dCB8 IDYgKysrLS0tCiAyIGZpbGVzIGNoYW5nZWQsIDQgaW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMo LSkKCmRpZmYgLS1naXQgYS9zcmMvYmluL3BzcWwvZGVzY3JpYmUuYyBiL3NyYy9iaW4vcHNxbC9k ZXNjcmliZS5jCmluZGV4IDRlOGZmMDAzOTRhLi4yOTFjNDkzZjU5NCAxMDA2NDQKLS0tIGEvc3Jj L2Jpbi9wc3FsL2Rlc2NyaWJlLmMKKysrIGIvc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMKQEAgLTMz MDYsNyArMzMwNiw3IEBAIGRlc2NyaWJlT25lVGFibGVEZXRhaWxzKGNvbnN0IGNoYXIgKnNjaGVt YW5hbWUsCiAJCQkJdHVwbGVzID0gUFFudHVwbGVzKHJlc3VsdCk7CiAKIAkJCWlmICh0dXBsZXMg PiAwKQotCQkJCXByaW50VGFibGVBZGRGb290ZXIoJmNvbnQsIF8oIkV4Y2VwdCBQdWJsaWNhdGlv bnM6IikpOworCQkJCXByaW50VGFibGVBZGRGb290ZXIoJmNvbnQsIF8oIkV4Y2VwdCBwdWJsaWNh dGlvbnM6IikpOwogCiAJCQkvKiBNaWdodCBiZSBhbiBlbXB0eSBzZXQgLSB0aGF0J3Mgb2sgKi8K IAkJCWZvciAoaSA9IDA7IGkgPCB0dXBsZXM7IGkrKykKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvcHVibGljYXRpb24ub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9wdWJsaWNhdGlvbi5vdXQKaW5kZXggYTkwNTlhMzkxMzguLmQwMjhlOWJlODY2IDEwMDY0NAot LS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dAorKysgYi9zcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dApAQCAtMjUyLDcgKzI1Miw3IEBA IEluZGV4ZXM6CiAgICAgInRlc3RwdWJfdGJsMV9wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlk KQogUHVibGljYXRpb25zOgogICAgICJ0ZXN0cHViX2ZvcmFsbHRhYmxlcyIKLUV4Y2VwdCBQdWJs aWNhdGlvbnM6CitFeGNlcHQgcHVibGljYXRpb25zOgogICAgICJ0ZXN0cHViX2ZvcmFsbHRhYmxl c19leGNlcHR0YWJsZSIKICAgICAidGVzdHB1Yl9mb3JhbGx0YWJsZXNfZXhjZXB0dGFibGUxIgog CkBAIC00MzUsNyArNDM1LDcgQEAgRXhjZXB0IHRhYmxlczoKIC0tLS0tLS0tKy0tLS0tLS0tLSst LS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLQogIGEgICAgICB8IGludGVnZXIgfCAgICAg ICAgICAgfCAgICAgICAgICB8IAogUGFydGl0aW9uIG9mOiB0ZXN0cHViX3Jvb3QgRk9SIFZBTFVF UyBGUk9NICgwKSBUTyAoMTAwKQotRXhjZXB0IFB1YmxpY2F0aW9uczoKK0V4Y2VwdCBwdWJsaWNh dGlvbnM6CiAgICAgInRlc3RwdWI4IgogCiBcZCB0ZXN0cHViX3Jvb3QKQEAgLTQ0NCw3ICs0NDQs NyBAQCBFeGNlcHQgUHVibGljYXRpb25zOgogLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0rLS0tLS0tLS0tCiAgYSAgICAgIHwgaW50ZWdlciB8ICAgICAgICAgICB8ICAg ICAgICAgIHwgCiBQYXJ0aXRpb24ga2V5OiBSQU5HRSAoYSkKLUV4Y2VwdCBQdWJsaWNhdGlvbnM6 CitFeGNlcHQgcHVibGljYXRpb25zOgogICAgICJ0ZXN0cHViOCIKIE51bWJlciBvZiBwYXJ0aXRp b25zOiAxIChVc2UgXGQrIHRvIGxpc3QgdGhlbS4pCiAKLS0gCjIuNDcuMwoK --000000000000a7acfc064f50b1c5--