On 26 October 2010 16:29, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
Thanks for the answer, I didn't know about the foreign key, I only thought
about the future use.
regards
Szymon