serial type as foreign key referential integrity violation - Mailing list pgsql-hackers

From leozc@cse.unsw.edu.au (Zhicong Leo Liang)
Subject serial type as foreign key referential integrity violation
Date
Msg-id f1f5c8c3.0208310428.93db45b@posting.google.com
Whole thread Raw
Responses Re: serial type as foreign key referential integrity violation  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: serial type as foreign key referential integrity  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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!


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.3 gotchas for applications and client libraries
Next
From: mlw
Date:
Subject: Re: contrib/ intarray, ltree, intagg broken(?) by array