serial type as foreign key referential integrity violation

Поиск
Список
Период
Сортировка
От leozc@cse.unsw.edu.au (Zhicong Leo Liang)
Тема serial type as foreign key referential integrity violation
Дата
Msg-id f1f5c8c3.0208310428.93db45b@posting.google.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.3 gotchas for applications and client libraries
Следующее
От: mlw
Дата:
Сообщение: Re: contrib/ intarray, ltree, intagg broken(?) by array