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 1wfjxr-005dL7-2C for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jul 2026 19:54:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wfjxq-008vtA-1W for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jul 2026 19:54:18 +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 1wfjxq-008vt1-0S for pgsql-hackers@lists.postgresql.org; Fri, 03 Jul 2026 19:54:18 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wfjxn-00000001MHn-4Ad3 for pgsql-hackers@lists.postgresql.org; Fri, 03 Jul 2026 19:54:16 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-80e2cfe6918so11171987b3.0 for ; Fri, 03 Jul 2026 12:54:15 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783108455; cv=none; d=google.com; s=arc-20260327; b=CGET05XhiIX/gFClV+2UvoQ1prlflgZDVLEHqj2KK22SuCsMpkfq7/AiGWru7j4zXb BYrX24giBfMdmMrtAOgJAgaWirTV3vndGOGLMXWkrG7nbCFmO73UiC+JFnDR+Le1WOGd 9ihFjk92pBnuOCdTElSR7hnKCJlnTzvY6K0Mw/QQPaBMNFlya+vBpdqxftcVGAx5LZQB iRUCN5xRmpQD+qESH05KIOeomaHAfssFKXwqoIwr2mbpBwcIeF7Xuj0hJn6QKBegvGnL 6ImVOPq58vD8yRmxXXDuxLEAv5EB4cASuADGbv0QjkLO87WME6zuUb+ZQ/0FqieTau31 frLw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=2715zkyjyLxJQVxgDT+A42/t2k862O3fThIwZk0ZPJ4=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=EW/DfAtLDdFCPq6Wvl/YilsHhWlf3HMAUSp271mC+dtZOdXK4SO3yW40GqU3+9AJ5q vvz2WA994ulSE9cbhdcRFsyazzhnKp/hwXO+Fq39xH5cA7uaRa+Wi5tjMsmyyem7UTVW Zi2qBm6am2wjlhWEwgmr2saM7BC1DeHuMAZnLMuAAKNtcYnNIdl54pAE2RpJghWl2hAD ZglF3LzLkEuSdxze/nrWdkUNKQz4VaCkAD0gXmooPFYeYeL+FaQmIntspcULndf6xOd9 nX+Drhjj+z9Yy3cCfVrR0FlZMK5lOTTXJk4mjX1ngU0dcqvb9mm3ml/B3AOA2GshctsZ qnYQ==; 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=percona.com; s=google; t=1783108455; x=1783713255; darn=lists.postgresql.org; h=content-type:to:subject:message-id:date:mime-version:references :in-reply-to:from:from:to:cc:subject:date:message-id:reply-to :content-type; bh=2715zkyjyLxJQVxgDT+A42/t2k862O3fThIwZk0ZPJ4=; b=ABIcCGT6gZeuy8wVn9SNOqSo9HaZEZaR47BfB+OekjvTsGBEonPB4HUXKFyiFSDgNj MHfqfWO8oHXdV4CApvh4Kkj+UtNHDa1io+MosOlT+QDSDIOLhNZBp0KX//ky+AMhrIhe dXeDEi9abTQCJ4t8hQ2G1aPrpyKlgcSaS1tNuoB9yugylhQtgTUdTES1qa+xElcgc/8B jOTYtSIUU4McJm/5QDRd0236FRkt+plV82XV0J023gia99z1SmKqB7xJUssUdC9h9EuO sLDiHK6W25oYnqhQwUi9OonhSOSPuwppCCyovuXgsu/N9lOkZbyaE6Dau3goQFPnOepA zJ2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783108455; x=1783713255; h=content-type:to:subject:message-id:date:mime-version:references :in-reply-to:from:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to:content-type; bh=2715zkyjyLxJQVxgDT+A42/t2k862O3fThIwZk0ZPJ4=; b=D99ct+FMk3O+NF2za73aPan++GewTfLFPe60Yj9eJtkS9wLFuXlX1lleb4uCgNBZB+ wmXBF5NAVdz9Jq/H+XI+9frgW5kJRAVIYBJdwshVFBQES5elf/UhP6+H7FABE2TI3CaX 9dKpjAG3fRkjc8sEHffFgYH5T16qapc9f8aqZBoUNIS+dw0rw5hmydmLfv8EqddMu4cM NABFFkUs1JeOAi/hlg2iOYO62I2gXmwzq8WdkeGcc3vhFTeJYUy53dsmF8/5XeqZILS6 q8Cxo9acmwKLfXRo6Cln/mwoQPFu2hoO6roRgIrQAKDZ3t+nB33iTvNMu9havWPv/Erq ZyLg== X-Gm-Message-State: AOJu0Yz3xLJZ4pqrrhyjGhGptTI2eR3nFUtYYOrHzIaWCX2MNQgBj4Bu /kEzeCBmDAd5qSuPqVEV7zOEdboAGTXVFpQuAOcajWgXNwe75H5PkAswnmR/0mdBpqxYT4pKxGQ Hf2/A1+C3350n8u3f9pq5lTcqD4aLke0c6lqsDiQHjkCw486d0XQRqgcLreJfrQ+1qozv7TQOwV RoeAegw8oSTHJ8y1HV6GoXa2f/0pwOj8G4s2KL0pSSyVMo4DhLKQegeOODVzc6eDZFsFgbNkXQp CmkY3yjJ+3PIcnY4fjBxUA+1Xcrrs6oQXwdHXgSKvFj8bW8YXO+fp8gG9F7nYbSuJoUSMmx4/vX tA== X-Gm-Gg: AfdE7cla8NgHSgiNg9+gVlUxAuA9hBQLPaBT0s/7Y7IJHDd/+/nLxHZ95KnFT0CPq/a 0zaK6gAVQn8M0LA6/ei898CJ87xrvxVwW5NMBEQq2nKMz/i9Er8Fhom+H4ztBtJiDI2579vVKE+ 8zENALwWJfSS5oCzfREIb09UgiqxOtl3WJPKyQrXnRzWuhfw77AmVuiQAB7Z99zG2U61RSoVshs X3c3hsOQfArpFBshrWKbf4ekfE4LPBmyMXpl62AuUNow0VsPC/o98iUbVOKeo4PTHHKU2zCt3eU /H/V92fqYC713Ls+WAP4XupyJmyHNChnchSubQx753EpMHh3GjjwJzsUJw== X-Received: by 2002:a05:690c:2502:b0:80c:85c6:8988 with SMTP id 00721157ae682-8173a6cd57cmr5333687b3.71.1783108454818; Fri, 03 Jul 2026 12:54:14 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Fri, 3 Jul 2026 15:54:14 -0400 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Fri, 3 Jul 2026 15:54:14 -0400 From: Zsolt Parragi In-Reply-To: References: <799A70FA-6E5C-4118-99EB-2FBBE1CBAC54@thebuild.com> <966B5430-8ECD-48FA-B56F-22452D9CDBBF@yandex-team.ru> <20260625.111954.696627555349573162.horikyota.ntt@gmail.com> MIME-Version: 1.0 Date: Fri, 3 Jul 2026 15:54:14 -0400 X-Gm-Features: AVVi8CdcmGbFz7WvK_w4PWuNd8mtf_iCKKY6lRENI5BcVGjiaymjJOzB5QIGO0s Message-ID: Subject: Re: uuidv7 improperly accepts dates before 1970-01-01 To: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk v4 looks good to me, I only have one completely optional nitpick comment: +-- uuidv7: large future intervals that overflow epoch conversion are rejected +SELECT uuidv7('292230 years'::interval); + There's no overflow anymore with the current patch, so that comment is somewhat stale. Maybe it could be simply "large future intervals are rejected"?