Thank you - this has worked perfectly
On Fri, Apr 27, 2012 at 10:18 PM, Richard Broersma
<richard(dot)broersma(at)gmail(dot)com> wrote:
> You could, but you don't need to since you can do all of this is one statement:
>
> ALTER TABLE public.pref_scores
> DROP CONSTRAINT pref_scores_gid_fkey,
> ADD CONSTRAINT pref_scores_gid_fkey
> FOREIGN KEY (gid)
> REFERENCES pref_games(gid)
> ON DELETE CASCADE;