Re: Silent overflow of interval type
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nick Babadzhanian <pgnickb@gmail.com>
Cc: Andrey Borodin <amborodin86@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2023-02-20T22:30:56Z
Lists: pgsql-hackers
Nick Babadzhanian <pgnickb@gmail.com> writes: > Please find attached the v2 of the said patch with the tests added. Pushed with light editing (for instance, I don't think interval.sql is the place to test timestamp operators, even if the result is an interval). > I don't know how the decision on > backpatching is made and whether it makes sense here or not. We haven't got a really hard policy on that, but in this case I elected not to, because it didn't seem worth the effort. It seems fairly unlikely that people would hit this in production. Also there's the precedent that related changes weren't backpatched. regards, tom lane
Commits
-
Detect overflow in timestamp[tz] subtraction.
- 8028e294b456 16.0 landed