pgsql: Disallow merging ONLY constraints in children tables

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Disallow merging ONLY constraints in children tables
Date: 2012-01-16 22:27:51
Message-ID: E1Rmv1r-0007ii-MZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Disallow merging ONLY constraints in children tables

When creating a child table, or when attaching an existing table as
child of another, we must not allow inheritable constraints to be
merged with non-inheritable ones, because then grandchildren would not
properly get the constraint. This would violate the grandparent's
expectations.

Bugs noted by Robert Haas.

Author: Nikhil Sontakke

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/3b11247aadf857bbcbfc765191273973d9ca9dd7

Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 6 +++++-
src/backend/catalog/heap.c | 19 +++++++++++++++----
src/backend/commands/tablecmds.c | 22 +++++++++++++++++-----
3 files changed, 37 insertions(+), 10 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2012-01-17 01:37:41 pgsql: fastgetattr is in access/htup.h, not access/heapam.h
Previous Message Peter Eisentraut 2012-01-16 18:10:06 pgsql: psql: Fix memory leak