Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 26 Oct 2010 16:37:58 +0200
- Message-id: <AANLkTi=u0ELrPV8s09kvVHrhBeqj-TcMqQ3UDvWAPjRP@mail.gmail.com> <text/plain>
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
- Follow-Ups:
- Why Select Count(*) from table - took over 20 minutes?
- From: Ozz Nixon
- Why Select Count(*) from table - took over 20 minutes?
- References:
- what can depend on index
- From: Szymon Guz
- Re: what can depend on index
- From: Tom Lane
- what can depend on index
- Prev by Date: Re: what can depend on index
- Next by Date: Why Select Count(*) from table - took over 20 minutes?
- Previous by thread: Re: what can depend on index
- Next by thread: Why Select Count(*) from table - took over 20 minutes?
- Indexes: