| From: | postgresbugs <postgresbugs(at)grifent(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Foreign keys referencing parent table fails on insert |
| Date: | 2004-12-03 18:12:24 |
| Message-ID: | 41B0AC88.8000802@grifent.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Stephan Szabo wrote:
<blockquote cite="mid20041202203001(dot)L37573(at)megazone(dot)bigpanda(dot)com"
type="cite">
<pre wrap="">On Thu, 2 Dec 2004, postgresbugs wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> On Wed, 1 Dec 2004, Stephan Szabo wrote:
On Wed, 1 Dec 2004, postgresbugs wrote:
> Foreign keys referencing parent table fails on insert if the key is in
</pre>
<blockquote type="cite">
<pre wrap="">the table that inherits the parent table.
</pre>
</blockquote>
<pre wrap="">
Unfortunately, primary keys, unique constraints and foreign keys do not
inherit to children in a meaningful fashion. It's one of the big
deficiencies right now.
Too bad. Table inheritance is pretty meaningless without these
abilities. Anyone working on them? In the meantime, I will go back to
views and updating the underlying tables.
</pre>
</blockquote>
<pre wrap=""><!---->
There's noone actively working on it at the moment that I know of (and if
there is, hopefully they'll see this and correct me) although I believe
there was some noise in the last dev cycle of people thinking about the
unique (and pkey) side of it.
</pre>
</blockquote>
Thanks. I would think that if the primary and unique keys worked
properly the foreign key problem would just fall out naturally. I would
volunteer for this except I do all my programing in JAVA these days and
my C and C++ are too rusty to be useful.<br>
<br>
I hope someone picks this up. It would go a long way in doing away with
the problems of views and inserts and updates.
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Kamholz | 2004-12-03 18:16:55 | utf-8 flag always off in plperl function arguments |
| Previous Message | Tom Lane | 2004-12-03 15:50:54 | Re: "invalid memory alloc request size <n>" in deferred trigger causes transaction to fail, but the backend keeps running |