Thank you - this has worked perfectly On Fri, Apr 27, 2012 at 10:18 PM, Richard Broersma <richard.broersma@xxxxxxxxx> 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; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
