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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
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-10 19:44:42
Message-ID: 19306.1194723882@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-committers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> My only fear is your reminder at a later date that we can't add feature
> X because of constant indexes and 8.4 is going to be all about indexes.

Well, if there's actually a reason to forbid it at some point, we can
reconsider.  Right now there is no such reason.  Furthermore, I rather
imagine that if there were a reason, the restriction it would require
would be a bit different than the one under discussion here.  If there's
something we want to do that cannot work with index expressions that
happen to be constants, it seems unlikely that adding a partial index
predicate would suddenly make it start to work.

			regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2007-11-10 20:14:36 pgsql: Add an example of a SQL function with output parameters returning
Previous Message Simon Riggs 2007-11-10 19:31:39 Re: pgsql: If an index depends on no columns of itstable, give it a