Re: Inheritance and foreign keys - Mailing list pgsql-general

From Brendan Jurd
Subject Re: Inheritance and foreign keys
Date
Msg-id 3FD4FC83.50205@blakjak.sytes.net
Whole thread Raw
In response to Re: Inheritance and foreign keys  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut wrote:<br /><blockquote cite="mid200312082138.54363.peter_e@gmx.net" type="cite"><pre
wrap="">BrendanJurd wrote: </pre><blockquote type="cite"><pre wrap="">I have a few projects that could benefit from
inheritedtable
 
structure, and it's a very cool idea, but this inability of indexes
to include derived tables is a real functionality-killer.  It's not
"Object Relational" if the objects can't be related to anything!   </pre></blockquote><pre wrap="">
Hehe, but the "relational" means that the data is stored in relations, 
not that the data has to be related to other data.
 </pre></blockquote> Fair call<br /><blockquote cite="mid200312082138.54363.peter_e@gmx.net" type="cite"><pre
wrap=""></pre><blockquotetype="cite"><pre wrap="">If someone could give me an idea of how far away this fix is, I'd be
 
grateful.   </pre></blockquote><pre wrap="">
No one has really expressed intentions to fix this, so I wouldn't hold 
my breath.
 </pre></blockquote> So it's a case of "if you really want it fixed, fix it yourself"?  If only I knew anything about
writingDBMS internals, I would have a shot at it.<br /><br /> /me proceeds to not hold breath<br /><br /> BJ<br /> 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is the COMMUTATOR clause required for self commutative operators?
Next
From: Socketd
Date:
Subject: OO database?