pgsql: Fix pg_get_constraintdef to cope with NOT VALID constraints

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix pg_get_constraintdef to cope with NOT VALID constraints
Date: 2011-06-03 20:06:27
Message-ID: E1QSadX-0002HL-G0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix pg_get_constraintdef to cope with NOT VALID constraints

This case was missed when NOT VALID constraints were first introduced in
commit 722bf7017bbe796decc79c1fde03e7a83dae9ada by Simon Riggs on
2011-02-08. Among other things, it causes pg_dump to omit the NOT VALID
flag when dumping such constraints, which may cause them to fail to
load afterwards, if they contained values failing the constraint.

Per report from Thom Brown.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/048417511aef8d5fb2d541b17b73afc730935cd5

Modified Files
--------------
src/backend/utils/adt/ruleutils.c | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tatsuo Ishii 2011-06-03 22:58:50 Re: [COMMITTERS] pgsql: Disallow SELECT FOR UPDATE/SHARE on sequences.
Previous Message Tom Lane 2011-06-03 19:39:43 pgsql: Fix failure to check whether a rowtype's component types are sor