Create a new GUC variable search_path to control the namespace search
Tom Lane <tgl@sss.pgh.pa.us>
Create a new GUC variable search_path to control the namespace search path. The default behavior if no per-user schemas are created is that all users share a 'public' namespace, thus providing behavior backwards compatible with 7.2 and earlier releases. Probably the semantics and default setting will need to be fine-tuned, but this is a start.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/runtime.sgml | modified | +65 −2 |
| src/backend/access/transam/xact.c | modified | +6 −4 |
| src/backend/catalog/namespace.c | modified | +208 −1 |
| src/backend/parser/gram.y | modified | +34 −4 |
| src/backend/utils/adt/varlena.c | modified | +98 −49 |
| src/backend/utils/init/postinit.c | modified | +16 −7 |
| src/backend/utils/misc/guc.c | modified | +9 −3 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −0 |
| src/bin/psql/tab-complete.c | modified | +2 −1 |
| src/include/access/xact.h | modified | +2 −4 |
| src/include/catalog/namespace.h | modified | +8 −1 |
| src/include/catalog/pg_namespace.h | modified | +2 −2 |
| src/include/utils/builtins.h | modified | +3 −1 |