Re: table inheritance and DB design

From: "Gevik Babakhani" <gevik(at)xs4all(dot)nl>
To: "'Alec Swan'" <aukcioner(at)yahoo(dot)com>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: table inheritance and DB design
Date: 2004-12-03 21:41:52
Message-ID: 200412032141.iB3Lfnml042407@smtp-vbr15.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are working on a PostgresSQL KB. Soon we are going to move the FAQ and
Information as such to the KB

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alec Swan
Sent: Friday, December 03, 2004 7:02 PM
To: Tom Lane
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] table inheritance and DB design

I understand your bang theory perfectly :) I just wanted to know if there
were plans to fix this.

I just looked at the TODO list at
http://developer.postgresql.org/todo.php and found the section with
inherited ref. constraints in the Indexes section.

On the TODO page it says: "A hyphen, "-", marks changes that will appear in
the upcoming 8.1 release.", but none of the items are marked with a hyphen.
I guess this TODO page needs to be updated.

Thanks.

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> > On Fri, Dec 03, 2004 at 08:24:38AM -0500, Berend
> Tober wrote:
> >> My personal take-away was that the behavior was
> not going to be fixed
> >> in the near term
>
> > The problem is that no developer is interested in
> fixing it (it's "low
> > on everyone's to-do list").
>
> Not even that so much as that fixing it looks very hard, and there is
> a great deal of other stuff to do that yields more bang for less work.
>
> regards, tom lane
>


__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2004-12-03 22:09:37 Dont let those int8's drive you mad!!
Previous Message Mike Cox 2004-12-03 21:27:21 Re: 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)