Re: Inheritance

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Copeland <greg(at)CopelandConsulting(dot)Net>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inheritance
Date: 2002-08-19 14:42:51
Message-ID: Pine.NEB.4.44.0208192337360.432-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 19 Aug 2002, Zeugswetter Andreas SB SD wrote:

> > So what you're saying is that constraints shouldn't be inherited?
>
> No. I even said that inheriting should be the default.

Ah. So you think it should be possible not to inherit constraints.

> A local constraint should be made obvious from looking at the schema,

Ok, this now I could live with. Though I'm not sure that its
theoretically very defensible, or worth the effort. Other languages
that offer constraints, such as Eiffel (and soon Java), do not allow
constraints that are not inherited, as far as I know. Do you have some
counterexamples.

> Well, that is where I do not think this is flexible enough, and keep in mind
> that all triggers and rules would then also need such restrictions.

Yes, all triggers, rules, and everything else would have to be inherited.

> Regardless whether your objection is *strong* or not :-)
> If you don't like the feature (to add a local constraint), don't use it.
> (Remember you are talking about removing an implemented feature)

1. It's not exactly an implemented feature, it's an accident of an
incomplete implementation of inheritance done in a certain way.

2. Should we change the way we decide to implement inheritance,
perhaps to make fixing the current problems much easier, it might
be a lot of work to add this.

cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2002-08-19 15:06:27 Re: Inheritance
Previous Message Tom Lane 2002-08-19 14:33:35 Re: Function result cacheing - any comments?