Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A84FF9FA2BA for ; Sat, 16 Dec 2006 12:58:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 53146-06 for ; Sat, 16 Dec 2006 12:58:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C40DE9FA252 for ; Sat, 16 Dec 2006 12:58:43 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBGGwgTQ000502; Sat, 16 Dec 2006 11:58:42 -0500 (EST) To: "Rajesh Kumar Mallah" cc: "Lista Postgres" Subject: Re: Adding a column with default value possibly corrupting a functional index. In-reply-to: References: Comments: In-reply-to "Rajesh Kumar Mallah" message dated "Sat, 16 Dec 2006 21:54:36 +0530" Date: Sat, 16 Dec 2006 11:58:42 -0500 Message-ID: <501.1166288322@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/235 X-Sequence-Number: 24027 "Rajesh Kumar Mallah" 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