Re: [GENERAL] Table Inheritance and foreign key problem.

2006-07-23 Thread Reece Hart
On Sun, 2006-07-23 at 14:59 +0300, Kostas Maistrelis wrote: > I make 3 tables with this senario: > b (id) extends a (id) > and > c (id) references a (id) > > i insert one record to table b (id = 1) > and then i try to insert a record in table C (id = 1) > but it is not possible, i get error > (l

Re: [GENERAL] Table Inheritance and foreign key problem.

2006-07-23 Thread Alvaro Herrera
Kostas Maistrelis wrote: > I make 3 tables with this senario: > b (id) extends a (id) > and > c (id) references a (id) > > i insert one record to table b (id = 1) > and then i try to insert a record in table C (id = 1) > but it is not possible, i get error > (look at the sql statements above) T

[GENERAL] Table Inheritance and foreign key problem.

2006-07-23 Thread Kostas Maistrelis
I make 3 tables with this senario: b (id) extends a (id) and c (id) references a (id) i insert one record to table b (id = 1) and then i try to insert a record in table C (id = 1) but it is not possible, i get error (look at the sql statements above) NOTE if the C (id) references the b (id) t