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?