| From: | Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | minor annoyance - search_path not reset in/after dump/restore | 
| Date: | 2017-11-27 14:04:19 | 
| Message-ID: | 3103514.ugGH0nFkBt@techfox | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
L.S.
I'm not sure the following qualifies as a 'real' bug, but since it suprised me, 
I'd like to raise it here, just in case it surprises others as well.
Postgresql version 9.6.6
The default value for the search_path is "$user", public.
Since I'm using schema's, my pg_dump files contain lines like this:
	SET search_path = cnt_user, pg_catalog;
for each particular schema part in the dump.
However, at the end of the dump file, there's nothing to restore the 
search_path to the default / last value.
This means that after restoring a dump via a psql console using a line like:
	\i /tmp/daily-db-backup
the search_path value will be equal to that of the last schema restored...
This causes unexpected output of commands like '\d' afterwards.
Obviously, disconnecting/reconnecting 'fixes' things.
--
Thanks,
Frank.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-11-27 15:08:58 | Re: BUG #14929: Unchecked AllocateDir() return value in restoreTwoPhaseData() | 
| Previous Message | PanBian | 2017-11-27 11:44:10 | Re: BUG #14929: Unchecked AllocateDir() return value in restoreTwoPhaseData() |