Re: Adding a column with default value possibly corrupting a functional index.

"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> I have an index on upper(general.cat_url(category_id)) on a table.
> when i add a column *with* default value , a query that previously
> used to give result does not give results anymore. REINDEX'ing the
> table produces correct result.

Can you provide a self-contained example of this?  What PG version are
you using?  What is that nonstandard function you're using in the index?

            regards, tom lane