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 1wcUGO-003O5l-2G for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2026 20:32:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcUGN-002Xgo-1Q for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jun 2026 20:31:59 +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 1wcUGN-002Xgg-0L for pgsql-hackers@lists.postgresql.org; Wed, 24 Jun 2026 20:31:59 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wcUGL-000000004zJ-0dMi for pgsql-hackers@lists.postgresql.org; Wed, 24 Jun 2026 20:31:57 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-7dd5a8dc8a2so11775057b3.0 for ; Wed, 24 Jun 2026 13:31:57 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782333116; cv=none; d=google.com; s=arc-20240605; b=YLhAXjunHJKjX2GdSYxhxzJ6IlJNt9cyepVuNR2IDWgrDRxDVOORhAGOKfWCI5z7Fh rwUkKuCdVxi8sjB/BU+RK/aiAtZxSE+cK6VklUChSla12eri+8MCU2rJ51U8Z6q8hQdm cZguyuPb34VAkOzipMLIwc0THSolRoub+6zDV38Nq6NbLmagf5TYhddh8dcOChQvVbmf ilmr0hIvcQI1Q/91wlwKX9mbj0b533RSnIdpeC4dKR671ggHE/nMskgREiSS+/xAinRp R0hYZZBOjm7ihaU4VyqyHZ/B1n7OaDW3QPDi0Wa7e7DJLHLD3QRa5xMdvK8hWbTD0IgD cSYg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=6JRD/Dez0M/Ci+JsM7oCU1jmTzjrcD0dDqvfFODZMLs=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=HCR3CQZc5PyqaoxVMskSb5RUPJnY0BzUkRaq1X6KciKVe9Kg0ICmLLJuYxZ7yW8i9Q XCPyaNQLH/2S3XoAubBAbzgAhc5I+o7amIRE1/ADkDH1Nv8fNc6/pKVTRXWbaOalk0nW K3O4fnSw/RDj93Vsndj1uD64wW1Y4gAHGpGk4ZKRcbZnleywgR5TQrEJBVO1fldWgp6o oT1buhH6nwdhpNBM1/TIX4KIIelmEG/q7XxCWaXPZ39RfUnzngOiH8zukbEtem0JrAJF urM6609GSadQUwytnjOwVnlskPoVrwAM+S/HGtXKy4nYqt2es2AHvZ+oQqlxCIAlfsyX lZgA==; 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=1782333116; x=1782937916; darn=lists.postgresql.org; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :from:to:cc:subject:date:message-id:reply-to; bh=6JRD/Dez0M/Ci+JsM7oCU1jmTzjrcD0dDqvfFODZMLs=; b=M3McWyG1WM7Jr2Wh0k5/P13bC5cTecuS0IMo3rfrcCNUL+7SE7hlDKiKWnoBwU16OF p0G33AdB/RMh5+DDlOb3cM8XB/ybFVcC/dOW85L2BlECX6jVe1wC+OdLGVezXiuf9RZG EVXeY8rLCGRaURGNy0nEriAuqtYT8PMj1GnPFbSL3CyEe2Pkf8K4Z58NahPf2tLORbDJ dFNkZqTRIjIsvGILLX7FBPAFLMlg15ruNaEU2EW+6rM+0sIVIgbwlPZu7F8DQRwedg0V jO/3IkP1t3b+xWx8pRbWyAgYryfPvZL6m+v3EQ6AG74qYi07d74A1pRlEfkc3eedZHeE RJqQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782333116; x=1782937916; h=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; bh=6JRD/Dez0M/Ci+JsM7oCU1jmTzjrcD0dDqvfFODZMLs=; b=AWio96GWowLW6RQW0BUxqQtWuJ6PBW7oqMu2+79LiPnBA2Vn7TQhX5o7eAoSQK5hUd +BxQMPxLQ+oAxEScX7TF8tPARuVnZUUhUlS7nWY+DyIswVbGnXIQS7wwijfRQ/gt/Ecl I5LOWh8CYZfc4P9/t7RZW1ZKphGWPDqMeCsnfbLC/xOhEH/6o3V2HrowbwmR2xxqK8o3 jTpRqZ/87dGSq3cmEqW3cW1sqITp5iy1Z4YL5pQENYF/sELUjqwbOvB1YqCfsTVqFokx 5NxlgXpH4gLKImt0YQww6yNsTrOLAgxEXr0JLeeAVTn/Fk+Yw5/POkOPJt4/1edI2HoM uzSQ== X-Gm-Message-State: AOJu0YzdzfI62Y7PSZTXmb2HiNWwQnu/NhbuEl1o7f/0qRdMnehCcqLN h52kqO7gXevOoTKiy1ljKFWEPAkorlEPTCWJhMB72Mvoy/lw6okYy5i/r1F5vWYXP2LXe+zr1tQ 9JlaPOSrqzO0+vXPIpfwC27io6f49BTbuSRg7kFiddNOfJqcqcM41jWRDuIsUYgjCxUVBprxLP6 3vbj5qUFtCrB6J07myZN6A8j7sC5skBAg9IUXhL5vuPirMti7b4RYUGvohRBsRZ9S5VG2nQ7P1b G9HSnbs25xZpH1np+anSjDrIt3VnKc/GSOFG3iZmuHMbJSDYQpSydbc85nQzat0s9Jaxav3/hV/ 5g== X-Gm-Gg: AfdE7ckXWGw4q+sTvIT/cI7wDKaY+02V2EmV067rcRM1qYcJRS9zaaqw1RTxaSgvfrD W+iWZFBSt8meyljFYNKGusBJmsBJyDabiwRPpjuHxLiTV37SP4SMZOd953KQ+dhG442V8cE0cJ+ Bta3Tm6m251d2N/sFRNGMTtdGp2HVr0LqCmQl+GT1PSAQTOh7cl/FmqzllysAbA2GR1V+mC1W6G LA3BwPDU9rmTnhNtoUFWFsyDY/wOlLlJpuZnUALO+GlDFidsBeBhV771CZw2SalOpFFdhMSS6f+ /39Q8Bn+L2M1c1GsT5XhoI/9jE+QC+TSfj2v6z2WxK1JY1rM5rj2Psmvt2ZftDGga+Rb X-Received: by 2002:a05:690c:4f06:b0:809:a7f4:247f with SMTP id 00721157ae682-809a7f42807mr23911477b3.5.1782333115549; Wed, 24 Jun 2026 13:31:55 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 24 Jun 2026 13:31:53 -0700 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 24 Jun 2026 13:31:53 -0700 From: Zsolt Parragi In-Reply-To: References: <799A70FA-6E5C-4118-99EB-2FBBE1CBAC54@thebuild.com> <966B5430-8ECD-48FA-B56F-22452D9CDBBF@yandex-team.ru> MIME-Version: 1.0 Date: Wed, 24 Jun 2026 13:31:53 -0700 X-Gm-Features: AVVi8CcquawSVpOlPDbwIGkCLoA-f924Y9A00OVJRIcjDAzyH9L0XCz9koCyDtY 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 Hello! `us` can overflow and while it still results in an error, it is in the wrong direction: SELECT uuidv7('292230 years'::interval); ERROR: timestamp out of range for UUID version 7 DETAIL: UUID version 7 does not support timestamps before the Unix epoch.