Re: tracking inherited columns (was: patch for check constraints using multiple inheritance) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: tracking inherited columns (was: patch for check constraints using multiple inheritance)
Date
Msg-id AANLkTimimQRcFjPB-8ErEJLex6dXKZ0T1zMZm4K=GuU9@mail.gmail.com
Whole thread Raw
In response to Re: tracking inherited columns (was: patch for check constraints using multiple inheritance)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Aug 5, 2010 at 9:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, if it were only a hint, and thus didn't actually "prevent"
> anything, then it wouldn't be breaking compatibility.  But I don't
> like the idea much either.  It would be extremely expensive, if not
> impossible, to determine whether all parents having the similarly-named
> column got it from the same common ancestor.  (In particular, if the
> user had previously ignored the hint, you could have situations where
> there isn't a unique ancestor that the column can be traced to; then
> what do you do?)
>
> I think we'd be putting huge amounts of effort into a case that no more
> than one or two people would ever hit.

I don't agree that it would be a huge amount of effort, but I do agree
that only a very small number of people will ever hit it, and that it
just doesn't seem worth it.  We have bigger fish to fry.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Adriano Lange
Date:
Subject: Re: TwoPO: experimental join order algorithm
Next
From: "Richard"
Date:
Subject: Re: Online backup cause boot failure, anyone know why?