foreign keys? - Mailing list pgsql-general

From Jeremy Hansen
Subject foreign keys?
Date
Msg-id Pine.LNX.4.30.0107211614530.10823-100000@srv1.ecropolis.com
Whole thread Raw
Responses Re: foreign keys?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: How Postgresql Compares For Query And Load Operations
Next
From: "Chris Mulcahy"
Date:
Subject: create function .... return record