f



BUG #1055: no keys in inherited table with primary key when inserting into inheriting table

The following bug has been logged online:

Bug reference:      1055
Logged by:          Agri

Email address:      agri@desnol.ru

PostgreSQL version: 7.4

Operating system:   PC-linux-gnu

Description:        no keys in inherited table with primary key when 
inserting into inheriting table 

Details: 

let me desribe a bug in the term of sql commands:
create table first (id int primary key );
create table second (f2 int) inherits (first);
create table third (ref_id int);
alter table third add constraint third_ref_first foreign key (ref_id) 
references first; 
insert into second (id, f2) values (1, 1);

and at last a bug insert:
insert into third (ref_id) values (1);
results in:
ERROR:  insert or update on table "third" violates foreign key constraint 
"third_ref_first" 

if i get a select:
select * from first;
 id 
----
  1
(1 row)

bug is: values are not added into primary key of the inherited table when 
records are inserted into the inheriting table 


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

0
pgsql
1/20/2004 3:22:30 PM
comp.databases.postgresql.bugs 1041 articles. 0 followers. Post Follow

0 Replies
743 Views

Similar Articles

[PageSpeed] 15

Reply: