Re: Table Inheritance and foreign key problem. - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Table Inheritance and foreign key problem.
Date
Msg-id 20060723141751.GA32088@surnet.cl
Whole thread Raw
In response to Table Inheritance and foreign key problem.  ("Kostas Maistrelis" <pinakas@gmail.com>)
List pgsql-general
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)

This is a known, documented shortcoming of our inheritance
implementation.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Kostas Maistrelis"
Date:
Subject: Table Inheritance and foreign key problem.
Next
From: "Joachim Wieland"
Date:
Subject: Re: ECPG. Badly stuck