pgsql-server/src backend/access/transam/xlog.c ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)svr1(dot)postgresql(dot)org 04/01/19 15:04:41

Modified files:
src/backend/access/transam: xlog.c
src/backend/catalog: namespace.c
src/backend/commands: variable.c
src/backend/utils/adt: datetime.c pg_locale.c regexp.c
src/backend/utils/misc: README guc.c
src/include/access: xlog.h
src/include/catalog: namespace.h
src/include/commands: variable.h
src/include/utils: builtins.h datetime.h guc.h guc_tables.h
pg_locale.h
src/interfaces/ecpg/pgtypeslib: dt.h

Log message:
Repair problem identified by Olivier Prenant: ALTER DATABASE SET search_path
should not be too eager to reject paths involving unknown schemas, since
it can't really tell whether the schemas exist in the target database.
(Also, when reading pg_dumpall output, it could be that the schemas
don't exist yet, but eventually will.) ALTER USER SET has a similar issue.
So, reduce the normal ERROR to a NOTICE when checking search_path values
for these commands. Supporting this requires changing the API for GUC
assign_hook functions, which causes the patch to touch a lot of places,
but the changes are conceptually trivial.