From: | "Chris Travers" <chris(at)travelamericas(dot)com> |
---|---|
To: | "Pedro" <pladen(at)elv(dot)enic(dot)fr>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: INHERITS and Foreign keys |
Date: | 2003-12-23 13:13:04 |
Message-ID: | 034e01c3c957$508902c0$52285e3d@winxp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi Pedro;
I understand that at the moment it is more of a design limitation than a
bug. I think we should vote the desired behavior as a feature request,
however.
Best Wishes,
Chris Travers
----- Original Message -----
From: "Pedro" <pladen(at)elv(dot)enic(dot)fr>
> >> Foreign keys, unique and primary key constraints do not meaningfully
> >> inherit currently. At some point in the future, that's likely to
change,
> >> but for now you're pretty much stuck with workarounds (for example,
using
> >> a separate table to store the ids and triggers/rules on each of the
> >> tables
> >> in the hierarchy in order to keep the id table in date.)
>
> hi
>
> same problem here on 7.4
> can we vote for this bug somewhere ?!
>
> thanks for your time
> Pedro
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | teknokrat | 2003-12-23 13:23:35 | Re: how do i get differences between rows |
Previous Message | Markus Bertheau | 2003-12-23 10:18:17 | Re: restoring database |