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