Re: ALTER CONSTRAINT change action

2018-05-30 Thread Euler Taveira
2018-05-30 13:23 GMT-03:00 Jeff Janes : > 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

ALTER CONSTRAINT change action

2018-05-30 Thread Jeff Janes
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