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 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
