Обсуждение: foreign keys?

Поиск
Список
Период
Сортировка

foreign keys?

От
Jeremy Hansen
Дата:
dta=> UPDATE test1 SET test_col=2;
ERROR:  <unnamed> referential integrity violation - key in test1 still
referenced from test2

I'm following the example in the elephant book on foreign keys and I'm
getting the above error on an update.  Has something changed on how
foreign keys work?

Thanks for any help.

My goal is to have another table update itself from a change in the
primary key of another table.  Foreign keys is what I should be using,
right?

Thanks
-jeremy

Re: foreign keys?

От
Stephan Szabo
Дата:
On Sat, 21 Jul 2001, Jeremy Hansen wrote:

>
> dta=> UPDATE test1 SET test_col=2;
> ERROR:  <unnamed> referential integrity violation - key in test1 still
> referenced from test2
>
> I'm following the example in the elephant book on foreign keys and I'm
> getting the above error on an update.  Has something changed on how
> foreign keys work?
>
> Thanks for any help.
>
> My goal is to have another table update itself from a change in the
> primary key of another table.  Foreign keys is what I should be using,
> right?

Is the foreign key defined with ON UPDATE CASCADE?