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 1wFMnh-0051IV-1k for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 01:54:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFMng-00BDGa-25 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 01:54:48 +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 1wFMng-00BDGK-1B for pgsql-hackers@lists.postgresql.org; Wed, 22 Apr 2026 01:54:48 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wFMne-00000002B9h-173e for pgsql-hackers@lists.postgresql.org; Wed, 22 Apr 2026 01:54:47 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-43d74086e5bso4819522f8f.0 for ; Tue, 21 Apr 2026 18:54:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776822885; cv=none; d=google.com; s=arc-20240605; b=OoYylAuPjw7+Ov+v0i0WX7DRTy8odCK48H1P9eyVBwRwXEvHJ1czGoP/yrWGhKXgbw 18IfeYn2N1MmH4vaO7v487nut2gbp3g+y6JY5aKxWLES5+rP06q95CdwgahgLF3WGdUZ /0zxUjqGzK4SE2F/I0hCTlf1dzIVzJXk+aSTvm4jf6jiGn2lbQTazR3O5S9tSDKB8ooc ajPfr39olgTAXHI69vGAL0mMO9a8mnAQvgeD9F0Sg2bjY2mmTVv5QW8BZNUDpQnPMC26 bBkuhrpx1sYo43J2jtN4fIru46TMQHsHXXBZEYR+CQzu6yjmcFrf0f+ZnbRK/qscBk6j lzRA== 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=XorR6YispNfzyLJwPAYTOnV8fWNeap62oWrcZTZzT00=; fh=RE7CblE6GcX9VUoO1ljNvYPaCWA3rTmhwyxupo8Rg0U=; b=D2utijhC0qinuA6D6aKuBIVYLJa57WnLG1t7FcYlXW72HZWPxvopZe0nb6LBoTfvZm tHPUwAkKVuC5Sm8QWBQ0vMo2GFT//YzrdrSY6xYdmkUGZKFNWTNw9ZTtWlBCu9oFzrFn jw8G4ZHIWVajFM9JyHZuuqXCCaD1+bABlZuXdR+BxUZQ4Sw4n5GhNeqj5ofkFsdaMxyT ooReLk/ZEWbIXEb7AlvCw9vkfU2GHA5E0suV6A1Unp/np+gwlzNxs/5L4i810jimPMaM QdzVIpNHITYMxqOB5ocI5O5itEO7hbFh7jDDdlZQMLmeSAFPfjmxuG57lOBwbfJuQk4W 30fw==; 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=1776822885; x=1777427685; 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=XorR6YispNfzyLJwPAYTOnV8fWNeap62oWrcZTZzT00=; b=WQrJ55FKUZE9G8vME7laLwqHXVGPm4A9soQ6r8BOcEeeIRWqdwk0sJ9zGiG96nKZBI EAqB4j0aETdMVKQuVN20cO4YvjbtCmPnN6gk6bSmet1TdqeakQ2vS0pHCvWlz8k2gQ02 PbBnFRoVvtAo+s/vwwo2KuJnhhSd15fUqvnPZ1cI5qelwVp9QPt74ejXpZ7In2Gqegd9 P7M3mEEjpMhhFmFqc0hCAxRbV47uwMPzYaWldbTx45HD2a9f9QFSr5U9N3ce6KGG9a0S HHsakfYRSWaSit5OpE0ynSdShbpU8KgCSyDUu/DOSpKCcsZxbNFIAeuK89coFL8vdVdG geVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776822885; x=1777427685; 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=XorR6YispNfzyLJwPAYTOnV8fWNeap62oWrcZTZzT00=; b=Zpt8iNobxJtW87JHWGWdOwXdm0GomEW9mfzl5yhwV/rpMkdFrE3DxeypqYiNsNLtgf R1pKxF5/4kRu5TVe56Yt1BsFxB7Kr6uv/ie1x533zTdK4RBRom541grgFraoyrcczSTM 228St6pbRRLVga0BF4eKMAKnJX6Ez7AlyEwjvLrEtx/ShQigbnDQ4Mg3n99luyxcO8ji AqNBtXmOMDARcKt2Mbh129jzKkHkEC8rCuL3PhwX7br0UUZwj2xv2qxsVwTi1rJoNqX7 gQvTmOxZM1JSsRYYc5O2RgqnS4vbSaboXGKZOn17yTOlTCmDUmO0NOw+tebh6W3hvts4 qZiw== X-Gm-Message-State: AOJu0YzRLXraHanLHtBpjQX4Tr3DfSp+UkFbsZZkG6FkbGF9cLyS4kw6 PHXFP+D5+3fsdzz8PMk2M2K7laV5UVUlYqcU+pJXrdjVb19QLoby0GDc7HBJUAY8tsmTKQVejgS QEY8vFFUzdAQxVTYO4wWvwDAgFGeH4ys= X-Gm-Gg: AeBDiesn3IhkLt+sx/XqSjW7Th+6ntf35N3oPp3/pXX3jZf96jKg+9nNHgq35WOvbEL TcjHJIP8MtJV9+hh4WeWkFm5CIlUIg7XovxcOwj99yiQI15FWIrgKl7wMxp4T9yhHkcEiiLp+82 OxI1497QCbYJorcxmF2hoFovO5FOOx/f4dJ5Wg+kj5WCwNy4N2p5965/sHeu+gEs3QUGMpZlf37 ulesU5tkL4Dcsrf7TlSN4p5Ck2zAyH8AYMZdQH/Jj1kilgkJOk9CXPi3cZQY0ORU8QoeIDjV+j5 AAUAV3/lAjYewdrsFMhPAo2Qn2C4qIu5uch9d1Cw8XdebjXKcXUtwlKvFa/0Wr8dYZR816i9YaS oXr5/tgJP X-Received: by 2002:a5d:6a09:0:b0:43f:e415:cb2 with SMTP id ffacd0b85a97d-43fe4150ce3mr20239152f8f.0.1776822885085; Tue, 21 Apr 2026 18:54:45 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Wed, 22 Apr 2026 13:54:33 +1200 X-Gm-Features: AQROBzCsQQigN-WJRhGehZ8D4RvrQwoCviDAP0xEyoIYI1l_zAYXGWEQYdy5ItE Message-ID: Subject: Re: [PATCH] Allow SJE to recognize GiST-backed temporal primary keys To: SATYANARAYANA NARLAPURAM Cc: PostgreSQL Hackers , Paul A Jungwirth Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 22 Apr 2026 at 07:18, SATYANARAYANA NARLAPURAM wrote: > relation_has_unique_index_for() checks whether join clause equality > operators belong to the index's opfamily via mergeopfamilies. Since > mergeopfamilies only lists btree opfamilies, this check always fails > for GiST-backed unique indexes such as those created by PRIMARY KEY > with WITHOUT OVERLAPS, preventing self-join elimination. Please add to the 20-1 CF [1]. David [1] https://commitfest.postgresql.org/59/