Re: what can depend on index

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: what can depend on index
Date: 2010-10-26 14:37:58
Message-ID: AANLkTi=u0ELrPV8s09kvVHrhBeqj-TcMqQ3UDvWAPjRP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ozz Nixon 2010-10-26 17:18:41 Why Select Count(*) from table - took over 20 minutes?
Previous Message Szymon Guz 2010-10-26 14:37:47 Re: what can depend on index