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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1tKjw5-00AVM1-70
	for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2024 20:00:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1tKjw2-00B8Tf-Kf
	for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2024 20:00:51 +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.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1tKjw2-00B8Sp-BK
	for pgsql-bugs@lists.postgresql.org; Mon, 09 Dec 2024 20:00:51 +0000
Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1tKjw1-001xGR-4V
	for pgsql-bugs@lists.postgresql.org; Mon, 09 Dec 2024 20:00:50 +0000
Received: by mail-io1-xd2f.google.com with SMTP id
 ca18e2360f4ac-843e3b49501so153520739f.0
        for <pgsql-bugs@lists.postgresql.org>;
 Mon, 09 Dec 2024 12:00:48 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1733774447; x=1734379247;
 darn=lists.postgresql.org;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=hQCD49DDygdDRhcrSx0h2pLyj93Nc7C4S64qD2IDDBc=;
        b=J230lUA1I1/MbFHOnHUnF+b9FuSDJA5MubOOlKzvv2VX1zSoZaAAQWMkEXcf7zJi8m
         rBP8kX3qyGHieWzB0wbCaw9d++Xng6qAJpwxjc6Medg5hgxNm8e5qDummsCBXuRGUj7y
         Bslty39VrSssG0jkW3Bo7xvrtcNuzXScrP/0QPadG6RIpXTX725Pk3LVLzk4nOoN35HP
         BIeUOcmJc/y/zI4Qpa+/zxUcZjMF0VEvAsWwphHzPct8g0HEqQYyhduXOSkaOlMMoNz/
         IdFoULj37WVaAUqrxlVKvSjeHcfEDSQZ3V13z0uJkmZZqUxM30fsx3J7rEhzE/6yOTrH
         BaPA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1733774447; x=1734379247;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=hQCD49DDygdDRhcrSx0h2pLyj93Nc7C4S64qD2IDDBc=;
        b=kvMGPl4EFloXswtTqi6KqvByYEojUh6r+eu2Flz8ThaiwnfrMl1WuivedXZ3gVF7wi
         aPEDcwqdDq/aHx7smF3HYQ1r3fLhtfCN6EheUvi7rOkoLuDgGERWtpzMvsiXyX3Kgdjx
         SC4DFXE5fu7knrr8J0DOzltRWhMrP1fz3fmCEGNx2IqjrlxR6YADJm8OSpHyjK3TAyor
         6tyCMvOxxpSGj/hEe/G8rzPQu61wMslkWbjnj6Zb/cVi2malzT0soa6bfSUff7c1IUMo
         InGwb9E1duB1t/rmnzaiWYwPpQkPW7x3Vjkd6MZtFuvex3O16ZaoFCHAYTyJUqHgWrdA
         EwNw==
X-Forwarded-Encrypted: i=1;
 AJvYcCVrMZF1hXzXjtoKNdNYj0HT+UXuIpIrFJZ1Dt28NgpVN7i6QbOTc0nP1POV6zAOM5oSXQ4J7bRbk/L4@lists.postgresql.org
X-Gm-Message-State: AOJu0YwKGFjYq1op7oMXInP+LuMpZ+GPF9KKfQCKGrPc9sHNR+yiYrPU
	LaoyWrdEQWfHVxVF1i5/pme72UglmoKwf1zig+EdEGNFIzsICY+cP9KfJg==
X-Gm-Gg: ASbGncsYNiLp0kQ9uYqC5sxrtSnWrZf/3tCnVI+nHdKwz+nzqvnxg7LOdqJXIzqVSF5
	hnDjgwUA0NMtrZrRNrTxqYQOAHVSHUkcpF1Sh2m56rzy/hHvbAy/UOu4EXAPkDnjFxnXGJsoYkk
	WLOw/nNAVG7RAqvzJczsCysSui5CP5wmHQjlC6E7p7i2HLJEYLfxH5jW6yCHCXPNDIe0cfNK8Y5
	soLmjSg/vP2DmlHRl1lT+gdIZUxRu1dpdFAyU/JkOg7gO7iZJTW3odpLO10R0WJzdHNpvVmLqoz
	wcDcNjNfJ2biJ1TLM0tn8zPyEV4mC24Vhk6y8jfwT3oZ
X-Google-Smtp-Source: 
 AGHT+IHp4N7xBUeF5sqJjEuv5agZ6cfobb9lWoTIjTJqu5WTBv1L8NuqnfPXuAGDBpx0La8PKcB0nw==
X-Received: by 2002:a05:6602:29cb:b0:843:e11e:e7f8 with SMTP id
 ca18e2360f4ac-844b522c4d1mr242325839f.12.1733774447213;
        Mon, 09 Dec 2024 12:00:47 -0800 (PST)
Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net.
 [162.195.168.172])
        by smtp.gmail.com with ESMTPSA id
 8926c6da1cb9f-4e2c835a054sm353668173.77.2024.12.09.12.00.46
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 09 Dec 2024 12:00:46 -0800 (PST)
Date: Mon, 9 Dec 2024 14:00:45 -0600
From: Nathan Bossart <nathandbossart@gmail.com>
To: Joseph Koshakow <koshy44@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, exclusion@gmail.com,
	pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18585: Date/time conversion functions are not protected
 against integer overflow
Message-ID: <Z1dMba3VCKOzshBy@nathan>
References: <18585-db646741dd649abd@postgresql.org>
 <964774.1723913132@sss.pgh.pa.us>
 <CAAvxfHc4jutMmVfRDwbxgeL7c6CKn4mpG+yfWTwcXCshM38FvA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAAvxfHc4jutMmVfRDwbxgeL7c6CKn4mpG+yfWTwcXCshM38FvA@mail.gmail.com>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: <https://www.postgresql.org/message-id/Z1dMba3VCKOzshBy%40nathan>
Precedence: bulk

For future reference, all of the above reports except for case 7 should be
fixed by commit 0a27c3d.

-- 
nathan