Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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(-)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group