]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Disallow infinite endpoints in generate_series() for timestamps.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 20 Apr 2022 22:08:15 +0000 (18:08 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 20 Apr 2022 22:08:15 +0000 (18:08 -0400)
commite7adbd282dbf9bd53f9bafc1fbb866cbe546af52
tree3ba4493096b9aef4f0ecd8c8b49f3bee0f4250b7
parent9130f8cbb91954f7a40de70c014c01b552df31da
Disallow infinite endpoints in generate_series() for timestamps.

Such cases will lead to infinite loops, so they're of no practical
value.  The numeric variant of generate_series() already threw error
for this, so borrow its message wording.

Per report from Richard Wesley.  Back-patch to all supported branches.

Discussion: https://postgr.es/m/91B44E7B-68D5-448F-95C8-B4B3B0F5DEAF@duckdblabs.com
src/backend/utils/adt/timestamp.c
src/test/regress/expected/timestamp.out
src/test/regress/expected/timestamptz.out
src/test/regress/sql/timestamp.sql
src/test/regress/sql/timestamptz.sql