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
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
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