Re: table inheritance and DB design

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[(at)]dcc(dot)uchile(dot)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)