pgsql: After a MINVALUE/MAXVALUE bound, allow only more of the same.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: After a MINVALUE/MAXVALUE bound, allow only more of the same.
Date: 2017-09-16 01:38:01
Message-ID: E1dt23V-00065n-1B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

After a MINVALUE/MAXVALUE bound, allow only more of the same.

In the old syntax, which used UNBOUNDED, we had a similar restriction,
but commit d363d42bb9a4399a0207bd3b371c966e22e06bd3, which changed the
syntax, eliminated it. Put it back.

Patch by me, reviewed by Dean Rasheed.

Discussion: http://postgr.es/m/CA+Tgmobs+pLPC27tS3gOpEAxAffHrq5w509cvkwTf9pF6cWYbg@mail.gmail.com

Branch
------
REL_10_STABLE

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

Modified Files
--------------
doc/src/sgml/ref/create_table.sgml | 11 ++++---
src/backend/parser/parse_utilcmd.c | 48 ++++++++++++++++++++++++++++++
src/test/regress/expected/create_table.out | 12 ++++----
src/test/regress/expected/inherit.out | 4 +--
src/test/regress/expected/insert.out | 35 +++++++++++++++-------
src/test/regress/sql/create_table.sql | 6 ++--
src/test/regress/sql/inherit.sql | 4 +--
src/test/regress/sql/insert.sql | 19 +++++++-----
8 files changed, 102 insertions(+), 37 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andreas Seltenreich 2017-09-16 10:55:46 Re: pgsql: Expand partitioned table RTEs level by level, without flattening
Previous Message Robert Haas 2017-09-16 01:35:43 Re: Re: [COMMITTERS] pgsql: Use MINVALUE/MAXVALUE instead of UNBOUNDED for range partition b