Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group