Postgres Pro
Downloads
Home   >   mailing lists

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

From Rajesh Kumar Mallah
Subject Re: Adding a column with default value possibly corrupting a functional index.
Date
Msg-id a97c77030612160941v1b1ed253v91107e12781f2ff7@mail.gmail.com
Whole thread Raw
In response to Re: Adding a column with default value possibly corrupting a functional index.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
List pgsql-admin
Tree view
 

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;

pgsql-admin by date:

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