Horton

Prevent a rowtype from being included in itself via a range.

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

View on postgr.es
Commit: 354d913f9745c4ce39c891d9a73b0b2535fd9c4c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2019-12-23T17:08:24Z
Releases: 9.6.17 
Prevent a rowtype from being included in itself via a range.

We probably should have thought of this case when ranges were added,
but we didn't.  (It's not the fault of commit eb51af71f, because
ranges didn't exist then.)

It's an old bug, so back-patch to all supported branches.

Discussion: https://postgr.es/m/7782.1577051475@sss.pgh.pa.us

Files

PathChange+/−
src/backend/catalog/heap.c modified +9 −0
src/test/regress/expected/rangetypes.out modified +3 −0
src/test/regress/sql/rangetypes.sql modified +3 −0

Discussion