Mai Peng <maily.peng@xxxxxxxxxxxxxxxxx> writes: > Is there a difference between an autoanalyze and a manual analyze ? autoanalyze runs with a restrictive search_path setting. > I got an error when I simply select from a function This suggests that your function isn't being sufficiently careful to schema-qualify names it uses. (If you don't want to change the function text, adding a SET clause to force the desired search_path would work, though it does carry a bit of performance penalty.) regards, tom lane
