BUG #6054: Insert to table, which has fkey to table, which is parenttable for another table - error

From: "Alex" <alexander(dot)ochkalyuk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6054: Insert to table, which has fkey to table, which is parenttable for another table - error
Date: 2011-06-07 12:44:26
Message-ID: 201106071244.p57CiQfg068192@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6054
Logged by: Alex
Email address: alexander(dot)ochkalyuk(at)gmail(dot)com
PostgreSQL version: 8.4.8
Operating system: CentOS
Description: Insert to table, which has fkey to table,which is
parenttable for another table - error
Details:

CREATE TABLE t1
(t1_id numeric(10,0) NOT NULL PRIMARY KEY);

CREATE TABLE t2
(t2_id numeric(10,0) NOT NULL PRIMARY KEY) INHERITS (t1);

CREATE TABLE t3
(t3_id numeric(10,0) NOT NULL PRIMARY KEY ,
t1_id numeric(10,0) NOT NULL REFERENCES t1(t1_id)) ;

INSERT INTO t2 VALUES(1,2);
INSERT INTO t3 VALUES(3,1);

ERROR: insert or update on table "t3" violates ---
foreign key constraint "t3_t1_id_fkey"
DETAIL: Key (t1_id)=(1) is not present in table "t1".

BUT!!!!
SELECT t1_id FROM t1 WHERE t1_id = 1;
-->1

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2011-06-07 14:24:12 Re: BUG #6041: Unlogged table was created bad in slave node
Previous Message Robert Haas 2011-06-07 12:16:01 Re: BUG #6041: Unlogged table was created bad in slave node