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
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 |