Re: what can depend on index

[Szymon Guz <mabewlun@xxxxxxxxx>]

On 26 October 2010 16:29, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Szymon Guz <mabewlun@xxxxxxxxx> 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