pgsql: Fix another bug in merging of inherited CHECK constraints.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix another bug in merging of inherited CHECK constraints.
Дата
Msg-id E1bunC7-0007oy-2S@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix another bug in merging of inherited CHECK constraints.

It's not good for an inherited child constraint to be marked connoinherit;
that would result in the constraint not propagating to grandchild tables,
if any are created later.  The code mostly prevented this from happening
but there was one case that was missed.

This is somewhat related to commit e55a946a8, which also tightened checks
on constraint merging.  Hence, back-patch to 9.2 like that one.  This isn't
so much because there's a concrete feature-related reason to stop there,
as to avoid having more distinct behaviors than we have to in this area.

Amit Langote

Discussion: <b28ee774-7009-313d-dd55-5bdd81242c41@lab.ntt.co.jp>

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/6f2db29ecb3c2bdb57dd11b5fec85af637e6602f

Modified Files
--------------
src/backend/catalog/heap.c            | 11 +++++++++++
src/test/regress/expected/inherit.out |  3 +++
src/test/regress/sql/inherit.sql      |  3 +++
3 files changed, 17 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix another bug in merging of inherited CHECK constraints.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix another bug in merging of inherited CHECK constraints.