Re: what can depend on index - Mailing list pgsql-general

From Tom Lane
Subject Re: what can depend on index
Date
Msg-id 24385.1288103385@sss.pgh.pa.us
Whole thread Raw
In response to what can depend on index  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: what can depend on index  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: what can depend on index
Next
From: Szymon Guz
Date:
Subject: Re: what can depend on index