Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding a column with default value possibly corrupting a functional index. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Adding a column with default value possibly corrupting a functional index.
Date
Msg-id 501.1166288322@sss.pgh.pa.us
Whole thread Raw
In response to Adding a column with default value possibly corrupting a functional index.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Responses Re: Adding a column with default value possibly corrupting a functional index.
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Adding a column with default value possibly corrupting a functional index.
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Adding a column with default value possibly corrupting a functional index.