Doc'd that PostgreSQL specifies CASCADE when dropping columns. #18066
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Submitting an admonition for a gotcha that a colleague spent some time on – they had some views go missing and were wondering what caused it.
I understand that CASCADE may be based on the fact that PG will abort any ALTER TABLE … DROP COLUMN statement if there are any objects dependent on that column 👍 Though probably not a bad idea to just clarify that here. (We could also adjust the wording to say this?)