Re: [SQL] INHERITS and Foreign keys

2003-12-23 Thread Chris Travers
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" <[EMAIL PROTECTED]> > >> Foreign keys, unique and primary key

Re: [SQL] INHERITS and Foreign keys

2003-12-22 Thread Pedro
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

Re: [SQL] INHERITS and Foreign keys

2003-12-13 Thread [EMAIL PROTECTED]
At 20:55 12/13/2003, you wrote: On Sat, 13 Dec 2003, [EMAIL PROTECTED] wrote: > Hi > > I have some problem with INHERITS and foreign keys. I do not know if I have > not got the clue or not. Anyway I have tried to simplify the problem so > that you can guide me on the right track. Foreign keys, un

Re: [SQL] INHERITS and Foreign keys

2003-12-13 Thread Stephan Szabo
On Sat, 13 Dec 2003, [EMAIL PROTECTED] wrote: > Hi > > I have some problem with INHERITS and foreign keys. I do not know if I have > not got the clue or not. Anyway I have tried to simplify the problem so > that you can guide me on the right track. Foreign keys, unique and primary key constraint

[SQL] INHERITS and Foreign keys

2003-12-13 Thread [EMAIL PROTECTED]
Hi I have some problem with INHERITS and foreign keys. I do not know if I have not got the clue or not. Anyway I have tried to simplify the problem so that you can guide me on the right track. I have two slightly different object A and B where 95% is common both of data and operations. Among t