Re: [GENERAL] what can depend on index

2010-10-26 Thread Szymon Guz
On 26 October 2010 16:29, Tom Lane wrote: > Szymon Guz 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

Re: [GENERAL] what can depend on index

2010-10-26 Thread Szymon Guz
On 26 October 2010 16:21, David Fetter wrote: > On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote: > > Hi, > > 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? > > A foreign key can, if the

Re: [GENERAL] what can depend on index

2010-10-26 Thread Tom Lane
Szymon Guz 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

Re: [GENERAL] what can depend on index

2010-10-26 Thread David Fetter
On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote: > Hi, > 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? A foreign key can, if the index is unique. Cheers, David. -- David Fetter http://fet

[GENERAL] what can depend on index

2010-10-26 Thread Szymon Guz
Hi, 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? regards Szymon