Re: [Bizgres-general] A Guide to Constraint Exclusion

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, bizgres-general(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [Bizgres-general] A Guide to Constraint Exclusion
Date: 2005-07-15 14:59:17
Message-ID: 20050715075450.H76091@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Fri, 15 Jul 2005, Hannu Krosing wrote:
> What comes to Toms's May 20 argument that people would be surprised when
> they select form a table whith check(i>0) constraint and get out i<0
> then I think this is a question of education.

I potentially disagree. What are we trying to model here? Systems which
allow children to have values that are not in the domain of the parent are
useful for some things, but they also potentially lose some other useful
properties like substitutability since a child isn't a parent (or more
specifically f(parent) cannot assume parent's invarients are valid on its
argument which may be a child unless they are applied to the child at call
time).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Karasik 2005-07-15 15:17:01 prepared queries in plperl
Previous Message Andrew Dunstan 2005-07-15 14:31:57 Re: multibyte regression tests