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