possible bug : pg_dump does not include ALTER DATABASE SET search_path
Started by Miles Keatonover 20 years ago2 messagesgeneral
possible bug :
pg_dump does not include ALTER DATABASE ... SET search_path TO ...
pg_dumpall does include it.
pg_dump only includes the runtime "SET search_path", but not the permanent
ALTER DATABASE part
is this intentional?
Re: possible bug : pg_dump does not include ALTER DATABASE SET search_path
Miles Keaton <mileskeaton@gmail.com> writes:
pg_dump does not include ALTER DATABASE ... SET search_path TO ...
pg_dumpall does include it.
This is per design; it holds for all ALTER DATABASE properties not
just search_path.
regards, tom lane