Horton

If a range-partitioned table has no default partition, reject null keys.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 2d7950f2222c97bd9d9f4d4edc1b59e6660c3621
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-11-28T19:11:16Z
Releases: 11.0 
If a range-partitioned table has no default partition, reject null keys.

Commit 4e5fe9ad19e14af360de7970caa8b150436c9dec introduced this
problem.  Also add a test so it doesn't get broken again.

Report by Rushabh Lathia.  Fix by Amit Langote.  Reviewed by Rushabh
Lathia and Amul Sul.  Tweaked by me.

Discussion: http://postgr.es/m/CAGPqQf0Y1iJyk4QJBdMf=pS9i6Q0JUMM_h5-qkR3OMJ-e04PyA@mail.gmail.com

Files

PathChange+/−
src/backend/catalog/partition.c modified +2 −3
src/test/regress/expected/insert.out modified +4 −0
src/test/regress/sql/insert.sql modified +3 −0

Discussion