Re: [GENERAL] Changing the function used in an index.

2013-07-12 Thread Tom Lane
Clodoaldo Neto writes: > How does the planner know that the function used in an index has changed? > If the function's body is changed keeping the argument and return types the > planner will not use it anymore: Ordinarily, changing a function definition like that *would* break things. The only

Re: [GENERAL] Changing the function used in an index.

2013-07-12 Thread David Johnston
Clodoaldo Neto wrote > How does the planner know that the function used in an index has changed? > If the function's body is changed keeping the argument and return types > the > planner will not use it anymore: Not a hacker but the function catalog entry is MVCC just like any other record and so

[GENERAL] Changing the function used in an index.

2013-07-12 Thread Clodoaldo Neto
How does the planner know that the function used in an index has changed? If the function's body is changed keeping the argument and return types the planner will not use it anymore: create table t (i integer); insert into t (i) select generate_series(1, 10); analyze t; A simple function to r