Re: table inheritance and DB design - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: table inheritance and DB design
Date
Msg-id 20041203144104.GB17701@dcc.uchile.cl
Whole thread Raw
In response to Re: table inheritance and DB design  ("Berend Tober" <btober@computer.org>)
Responses Re: table inheritance and DB design  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Dec 03, 2004 at 08:24:38AM -0500, Berend Tober wrote:
> > On Thu, Dec 02, 2004 at 10:53:37PM -0500, Berend Tober wrote:
> >
> >> I learned that the unusual behavior (or at least the behavior that
> >> seems weird to me) regarding relational integrity and uniquness
> >> constraints as been around for a while, and some people actually think
> >> is is SUPPOSED to work that way ...
> >
> > Who would that be?  Because I've always thought that most people
> > (everyone?) think of it as a bug that nobody has bothered to fix.  Not
> > that the fix is easy, mind you ...
>
> Sorry, I can't name names from recollection.

Sorry, that comment was not actually meant to make you name someone, it
was a manner of speaking.

> 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").  But I think you would have a hard time
finding someone to defend the current behavior as desirable.

> And don't say "fix it yourself" because I might be inclined to try, if
> I had the appropriate skills.

I don't see that as a problem ... in fact, that's how this project
works.  If you are annoyed with the current situation, you are welcome
to change it.  Postgres _is_ open source after all, unlike some other
database system which claims the name but disdains the methodology ...

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: reclaiming diskspace bloat w/near-zero downtime
Next
From: Alec Swan
Date:
Subject: Re: table inheritance and DB design