Re: pgsql: If an index depends on no columns of its table, give it a

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: If an index depends on no columns of its table, give it a
Date: 2007-11-09 08:35:17
Message-ID: 1194597317.4251.354.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Thu, 2007-11-08 at 23:22 +0000, Tom Lane wrote:
> Log Message:
> -----------
> If an index depends on no columns of its table, give it a dependency on the
> whole table instead, to ensure that it goes away when the table is dropped.
> Per bug #3723 from Sam Mason.
>
> Backpatch as far as 7.4; AFAICT 7.3 does not have the issue, because it doesn't
> have general-purpose expression indexes and so there must be at least one
> column referenced by an index.
>

I had understood the discussion to conclude that indexes that do not
depend on any column of the table to not be allowed at all.

Why would anyone want this? (There was a workaround to the original
thought). What value is there in allowing such strange cases?

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2007-11-09 09:05:58 Re: pgsql: If an index depends on no columns of its table, give it a
Previous Message Bruce Momjian 2007-11-09 02:32:09 Fix for stop words in thesaurus file