Re: Inheritance and foreign keys

From: Brendan Jurd <blakjak(at)blakjak(dot)sytes(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance and foreign keys
Date: 2003-12-08 22:34:43
Message-ID: 3FD4FC83.50205@blakjak.sytes.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
Peter Eisentraut wrote:<br>
<blockquote cite="mid200312082138(dot)54363(dot)peter_e(at)gmx(dot)net" type="cite">
<pre wrap="">Brendan Jurd wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have a few projects that could benefit from inherited table
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(dot)54363(dot)peter_e(at)gmx(dot)net" type="cite">
<pre wrap=""></pre>
<blockquote type="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"?&nbsp; If
only I knew anything about writing DBMS internals, I would have a shot
at it.<br>
<br>
/me proceeds to not hold breath<br>
<br>
BJ<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.5 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2003-12-08 22:57:30 Manual record locking
Previous Message Tom Lane 2003-12-08 22:29:53 Re: Is the COMMUTATOR clause required for self commutative operators?