Re: How to add "on delete cascade" constraints - Mailing list pgsql-general

On Fri, Apr 27, 2012 at 12:40 PM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> So it's not a problem to drop and recreate the FOREIGN KEYs?
>
> And can I use START TRANSACTION while doing it?

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;


--
Regards,
Richard Broersma Jr.