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

pgsql: Fix constraint exclusion to work in inherited UPDATE/DELETE

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix constraint exclusion to work in inherited UPDATE/DELETE
Date: 2006-02-04 23:03:20
Message-ID: 20060204230320.608579DC81E@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix constraint exclusion to work in inherited UPDATE/DELETE queries
... in fact, it will be applied now in any query whatsoever.  I'm still
a bit concerned about the cycles that might be expended in failed proof
attempts, but given that CE is turned off by default, it's the user's
choice whether to expend those cycles or not.  (Possibly we should
change the simple bool constraint_exclusion parameter to something
more fine-grained?)

Modified Files:
--------------
    pgsql/doc/src/sgml:
        config.sgml (r1.45 -> r1.46)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.45&r2=1.46)
        ddl.sgml (r1.51 -> r1.52)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml.diff?r1=1.51&r2=1.52)
    pgsql/src/backend/optimizer/path:
        allpaths.c (r1.141 -> r1.142)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c.diff?r1=1.141&r2=1.142)
        joinpath.c (r1.100 -> r1.101)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c.diff?r1=1.100&r2=1.101)
    pgsql/src/backend/optimizer/util:
        plancat.c (r1.117 -> r1.118)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/plancat.c.diff?r1=1.117&r2=1.118)
    pgsql/src/include/optimizer:
        plancat.h (r1.37 -> r1.38)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/plancat.h.diff?r1=1.37&r2=1.38)

pgsql-committers by date

Next:From: User DevrimDate: 2006-02-05 01:59:27
Subject: pgpool - pgpool: * Version 3.0.0 * Change copyright to
Previous:From: Tom LaneDate: 2006-02-04 22:38:39
Subject: pgsql: Fix broken markup.

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