Jerry Sievers <jerry@xxxxxxxxxxxxxxxx> 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
