Szymon Guz <mabewlun@gmail.com> writes: > today I noticed that in the documentation there is DROP INDEX CASCADE. > I've got one question: what is that for? What can depend on index?
Unique constraints and foreign key constraints, for starters.
But even if there weren't anything, we'd still provide the CASCADE syntax for future-proofing purposes.
regards, tom lane
Thanks for the answer, I didn't know about the foreign key, I only thought about the future use.
