search path is getting updated automatically In postgres 11.5 for a running session suddenly lot of errors reported in pg_logs &quot;relation does not exist&quot;. After enabling extra logging we have found out that just before the errors the following statement is getting executed and feels same is the culprit.
SELECT pg_catalog.set_config('search_path', '', false)

We are not running it. Could anyone please help me to understand by whom and under what circumstances it is getting executed.
Let me pull out my crystal ball and see what you did...
Ah! I see you restoring a plain format pg_dump from an interactive session using \i dumpfile, so that the settings from the dump remain active in your session after the restore is completed.