Table inheritance problem

From: "Gianvito Pio" <pio(dot)gianvito(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Table inheritance problem
Date: 2009-07-18 17:09:31
Message-ID: F5926D0F35F247FBAFC269BE450D5E7F@PCGianvito
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I have 3 tables: persons, operators and persons_position.

This is a semplified examples of their structures:

CREATE TABLE persons
(id varchar NOT NULL,
CONSTRAINT "PK_Persons" PRIMARY KEY(id));

CREATE TABLE operators
(id varchar NOT NULL,
CONSTRAINT "PK_Operators" PRIMARY KEY(id))
INHERITS(persons);

CREATE TABLE persons_position
(id bigserial NOT NULL,
person varchar NOT NULL);

and then there is a FOREIGN KEY CONSTRAINT from persons_position.person TO persons.id.

If I insert a tuple in operators...it results also in persons, but when I insert a tuple in persons_position, it says me I have violated the foreing key constraints. So it appears that the tuple really ISN'T in the persons table and the foreing key check fails.

How could I solve it, keeping the inheritance there?
Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2009-07-19 12:59:31 Re: Timestamp with timezone with Default value
Previous Message Jasmin Dizdarevic 2009-07-18 10:25:06 Re: Timestamp with timezone with Default value