PG Bug reporting form <noreply@postgresql.org> writes:
> Please run the script below. It creates sample table with partial index
> using IMMUTABLE function.
> I think when table is changing - index in changing and thus function used in
> WHERE cluse can be run.
> But it is not supposed to be run on just simple SELECT from table without
> even condition to use this index.
[ shrug... ] There is no bug here. The planner is entitled to
investigate the properties of indexes attached to a table it's
trying to plan for. Sure, this index is not relevant to this
query --- but how's the planner going to know that without
examining the index? And part of that examination involves
reducing any partial-index predicate to standard form, which
includes constant-folding. Since your function is marked
IMMUTABLE, that means it should be evaluated and reduced to
a constant.
Part of the contract for marking a function IMMUTABLE is that
it has no interesting side-effects. This example breaks that
in two ways: the RAISE NOTICE is a side-effect, and the
possibility of a permissions failure is another one.
regards, tom lane
