ALTER CONSTRAINT change action - Mailing list pgsql-hackers

From Jeff Janes
Subject ALTER CONSTRAINT change action
Date
Msg-id CAMkU=1wBEU=RJxtEMZ_UcXWoQrXUydACoF=-m40D8Sh9uESxeA@mail.gmail.com
Whole thread Raw
Responses Re: ALTER CONSTRAINT change action
List pgsql-hackers
Currently you can't change the ON DELETE action or ON UPDATE action of an existing constraint.   You have to drop the constraint and create it again with the action you want.  This is not a light-weight activity, as it has to validate the new constraint.

Is there a fundamental reason that ALTER TABLE...ALTER CONSTRAINT cannot change the action?  Or is just that no one got around to it?

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Avoid extra Sort nodes between WindowAggs when sorting can be reused
Next
From: Teodor Sigaev
Date:
Subject: Re: Few comments on commit 857f9c36 (skip full index scans )