Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB6D09F9FB2 for ; Sat, 16 Dec 2006 13:41:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 53772-10 for ; Sat, 16 Dec 2006 13:41:09 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id C3C389F9F08 for ; Sat, 16 Dec 2006 13:41:08 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1117693ugf for ; Sat, 16 Dec 2006 09:41:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=QoFRPO6fb0Cvd939pwgyUc6+1MBYWuN1pcGSlekJPAnST1XD3Igm3On3RLdYmociqKRpEzr4LftNeWiS16bAdvGyrUsPctpP0gYHo6HRzwxf6IIP30CLztu8fRnWIxkCTJLoUiKNUZmG7KEpg3sx4+Hfr2fQAi2b/1m4cP1D8YQ= Received: by 10.67.97.18 with SMTP id z18mr2080453ugl.1166290867217; Sat, 16 Dec 2006 09:41:07 -0800 (PST) Received: by 10.66.216.15 with HTTP; Sat, 16 Dec 2006 09:41:07 -0800 (PST) Message-ID: Date: Sat, 16 Dec 2006 23:11:07 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: Adding a column with default value possibly corrupting a functional index. Cc: "Lista Postgres" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2206_12933844.1166290867088" References: <501.1166288322@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/237 X-Sequence-Number: 24029 ------=_Part_2206_12933844.1166290867088 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline > > > Its declared immutable , it queries the same table , its recursive > and it queries another custom function also. > fyi dir_name is a simple plperlu function. my ($dir) = @_; $dir =~ s/&/and/g; $dir =~ s/&/and/g; $dir =~ s/[^a-zA-Z0-9]+/_/g; return $dir; ------=_Part_2206_12933844.1166290867088 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline  

Its declared immutable , it queries the same table , its recursive
and it queries another custom function also.

fyi dir_name  is a simple plperlu function.
 my ($dir) = @_;
 $dir =~ s/&amp;/and/g;
 $dir =~ s/&/and/g;
 $dir =~ s/[^a-zA-Z0-9]+/_/g;
 return $dir;

------=_Part_2206_12933844.1166290867088--