[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

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

Re: [GENERAL] what can depend on index

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

Re: [GENERAL] what can depend on index

2010-10-26 Thread Szymon Guz
On 26 October 2010 16:21, David Fetter da...@fetter.org 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,

Re: [GENERAL] what can depend on index

2010-10-26 Thread Szymon Guz
On 26 October 2010 16:29, Tom Lane t...@sss.pgh.pa.us wrote: Szymon Guz mabew...@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