insert or update on table violates foreign key constraint
- by sprasad12
Hi,
I have two tables entitytype and project. Here are the create table statements:
Create table project (
pname varchar(20) not null,
primary key(pname)
);
create table entitytype(
entityname varchar(20) not null,
toppos char(100),
leftpos char(100),
pname varchar(20) not null,
primary key(entityname),
foreign key(pname) references project(pname) on delete cascade on update cascade
);
Now when i try to insert any values into entitytype table i am getting the following error:
ERROR: insert or update on table "entitytype" violates foreign key constraint "entitytype_pname_fkey"
Detail: Key (pname)=(494) is not present in table "project".
Can someone please shed some light on what i am doing wrong. Any input will be of great help.
Thank you.
