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