inheritance and foreign key

From: Estelle_Littee(at)etu(dot)u-bourgogne(dot)fr
To: pgsql-general(at)postgresql(dot)org
Subject: inheritance and foreign key
Date: 2001-03-09 16:34:45
Message-ID: OF82071D3C.5D4378F0-ONC1256A0A.005B128F@etu.u-bourgogne.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We have the following schema :
create table A (id_A integer primary key,b_A integer);
create table B (a_B integer) inherits A;
create table C (id_C integer primary key, b_C integer);
create table D (id1 integer references A (id_A),
id2 integer references C (id_C),
primary key(id1, id2));

Problem occurs when we want to insert a tuple into D
that references a B's tuple. Our idea is :
create table D (id1 integer references A* (id_A),
id2 integer references C (id_C),
primary key(id1, id2));
which is not allowed by postgres.

Does anyone has experimented such problem?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2001-03-09 16:57:09 Re: Re: pgsql for Python
Previous Message Feite Brekeveld 2001-03-09 16:09:39 calling a fuction within a function