serial type as foreign key referential integrity violation

From: leozc(at)cse(dot)unsw(dot)edu(dot)au (Zhicong Leo Liang)
To: pgsql-hackers(at)postgresql(dot)org
Subject: serial type as foreign key referential integrity violation
Date: 2002-08-31 12:28:53
Message-ID: f1f5c8c3.0208310428.93db45b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,
Just briefly describe my problem.
I have two tables.
create table A(
a1 serial primary key,
a2 varchars(10)
);
create table B(
b1 integer primary key,
b2 Integer,
foreign key(b2) references a(a1)
)
insert into A values('123');
select a1 from A where a2='123'
>--
>a1
>--
>1
>--
insert into B values (1,1);
ERROR!! referential integrity violation - key referenced from B not found in A.

but in table A , if I change it the PK to integer, everything would be fine.

any idea?

thanks a lot!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-08-31 12:38:03 Re: [HACKERS] pgaccess - where to store the own data
Previous Message Alvaro Herrera 2002-08-31 05:52:59 Re: [HACKERS] pg_attribute.attisinherited ?