Horton

Disallow infinite endpoints in generate_series() for timestamps.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: e7adbd282dbf9bd53f9bafc1fbb866cbe546af52
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-04-20T22:08:15Z
Releases: 11.16 
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

Files

PathChange+/−
src/backend/utils/adt/timestamp.c modified +28 −0
src/test/regress/expected/timestamp.out modified +49 −0
src/test/regress/expected/timestamptz.out modified +49 −0
src/test/regress/sql/timestamp.sql modified +15 −0
src/test/regress/sql/timestamptz.sql modified +15 −0

Discussion