pgsql: Disallow infinite endpoints in generate_series() for timestamps. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Disallow infinite endpoints in generate_series() for timestamps.
Date
Msg-id E1nhIV3-000KSt-0N@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e7adbd282dbf9bd53f9bafc1fbb866cbe546af52

Modified Files
--------------
src/backend/utils/adt/timestamp.c         | 28 ++++++++++++++++++
src/test/regress/expected/timestamp.out   | 49 +++++++++++++++++++++++++++++++
src/test/regress/expected/timestamptz.out | 49 +++++++++++++++++++++++++++++++
src/test/regress/sql/timestamp.sql        | 15 ++++++++++
src/test/regress/sql/timestamptz.sql      | 15 ++++++++++
5 files changed, 156 insertions(+)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Allow db.schema.table patterns, but complain about random garbag
Next
From: Peter Geoghegan
Date:
Subject: pgsql: Fix CLUSTER tuplesorts on abbreviated expressions.