Re: [GENERAL] cascade and restrict options to alter domain drop constraint

2007-09-25 Thread Tom Lane
Marc Munro <[EMAIL PROTECTED]> 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

[GENERAL] cascade and restrict options to alter domain drop constraint

2007-09-25 Thread Marc Munro
I am puzzled by the cascade and restrict options to the alter domain drop constraint command. I do not see how a dropping a check constraint should cascade to anything, or indeed be restricted by anything. My reasoning is simple: if I drop a check constraint on a domain, no data should be affecte