Re: [GENERAL] foreign keys and inheritance problem

2010-08-12 Thread Edoardo Panfili
On 12/08/10 20.44, Tom Lane wrote: Edoardo Panfili writes: On 12/08/10 18.59, Edoardo Panfili wrote: I am in some trouble with my tables defined using inheritance, No, foreign keys do not play very nicely with inheritance. There is some explanation in the manual, in the "Caveats" subsection

Re: [GENERAL] foreign keys and inheritance problem

2010-08-12 Thread Tom Lane
Edoardo Panfili writes: > On 12/08/10 18.59, Edoardo Panfili wrote: >> I am in some trouble with my tables defined using inheritance, No, foreign keys do not play very nicely with inheritance. There is some explanation in the manual, in the "Caveats" subsection under "Inheritance" --- see bottom

Re: [GENERAL] foreign keys and inheritance problem

2010-08-12 Thread Edoardo Panfili
On 12/08/10 18.59, Edoardo Panfili wrote: hi, I am in some trouble with my tables defined using inheritance, This is a semplified test case: --- create table sub1( name1 text) inherits(father); create table sub2( name2 text) inherits(father); create table other (description t

[GENERAL] foreign keys and inheritance problem

2010-08-12 Thread Edoardo Panfili
hi, I am in some trouble with my tables defined using inheritance, This is a semplified test case: --- create table sub1( name1 text) inherits(father); create table sub2( name2 text) inherits(father); create table other (description text, id integer); -- I know, the contrai