Jerry Sievers <jerry@jerrysievers.com> writes:
> Any of these connections that may have previously executed PL
> functions which planned an index lookup are now going to fault if same
> index goes away.
> Had wondered if a postmaster 'reload' would elicit a recompiling of
> func query plans (did *not* see this in the docs but was hopeful...).
Starting a fresh session (database connection) is sufficient, you need
not bounce the postmaster as such.
We are looking at making replanning happen automatically after a schema
change; I'm hopeful that that gets done for 8.2.
regards, tom lane
