| From: | postgresbugs <postgresbugs(at)grifent(dot)com> |
|---|---|
| To: | 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-02 16:47:28 |
| Message-ID: | 41AF4720.3020503@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">
<pre wrap="">On Wed, 1 Dec 2004, Stephan Szabo wrote:</pre>
<blockquote type="cite">
<pre wrap=""><div class="moz-txt-sig">On Wed, 1 Dec 2004, postgresbugs wrote:
</div></pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> </span>Foreign keys referencing parent table fails on insert if the key is in
<span class="moz-txt-citetags">> </span>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.
</pre>
</blockquote>
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.<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Marshall | 2004-12-02 17:18:02 | pg_autovacuum getopt bun in 8.0.0beta5 |
| Previous Message | Tom Lane | 2004-12-02 16:42:39 | Re: Column names: where, group by, having inconsistent behaviour? |