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

From Tom Lane
Subject Re: pgsql: If an index depends on no columns of its table, give it a
Date
Msg-id 19306.1194723882@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: If an index depends on no columns of its table, give it a  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-committers
Simon Riggs <simon@2ndquadrant.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

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pgsql: If an index depends on no columns of its table, give it a
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add an example of a SQL function with output parameters returning