Marc Munro <marc(at)bloodnok(dot)com> writes:
> I am puzzled by the cascade and restrict options to the alter domain
> drop constraint command.
They don't do anything.
I think they were put in because we have this meme that the SQL spec
requires RESTRICT/CASCADE options on every type of DROP, but so far
as I can see, SQL99 has no such option for ALTER DOMAIN DROP CONSTRAINT.
So maybe it's a bug that we take the options for it. Or maybe it's
better to leave them there, in case people are expecting them to
be there on the same reasoning.
regards, tom lane