Szymon Guz <mabewlun(at)gmail(dot)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