SQL/MED catalog manipulation facilities

Peter Eisentraut <peter_e@gmx.net>

Commit: cae565e503c42a0942ca1771665243b4453c5770

Author: Peter Eisentraut <peter_e@gmx.net>

Date: 2008-12-19T16:25:19Z

SQL/MED catalog manipulation facilities

This doesn't do any remote or external things yet, but it gives modules
like plproxy and dblink a standardized and future-proof system for
managing their connection information.

Martin Pihlak and Peter Eisentraut

Files

Path	Change	+/−
doc/src/sgml/catalogs.sgml	modified	+324 −1
doc/src/sgml/features.sgml	modified	+3 −3
doc/src/sgml/func.sgml	modified	+53 −1
doc/src/sgml/information_schema.sgml	modified	+365 −23
doc/src/sgml/keywords.sgml	modified	+28 −4
doc/src/sgml/ref/allfiles.sgml	modified	+10 −1
doc/src/sgml/ref/alter_foreign_data_wrapper.sgml	added	+132 −0
doc/src/sgml/ref/alter_server.sgml	added	+123 −0
doc/src/sgml/ref/alter_user_mapping.sgml	added	+119 −0
doc/src/sgml/ref/create_foreign_data_wrapper.sgml	added	+185 −0
doc/src/sgml/ref/create_server.sgml	added	+140 −0
doc/src/sgml/ref/create_user_mapping.sgml	added	+111 −0
doc/src/sgml/ref/drop_foreign_data_wrapper.sgml	added	+112 −0
doc/src/sgml/ref/drop_server.sgml	added	+112 −0
doc/src/sgml/ref/drop_user_mapping.sgml	added	+104 −0
doc/src/sgml/reference.sgml	modified	+10 −1
doc/src/sgml/ref/grant.sgml	modified	+21 −5
doc/src/sgml/ref/psql-ref.sgml	modified	+59 −1
doc/src/sgml/ref/revoke.sgml	modified	+13 −1
src/backend/catalog/aclchk.c	modified	+469 −3
src/backend/catalog/dependency.c	modified	+73 −1
src/backend/catalog/information_schema.sql	modified	+242 −15
src/backend/catalog/Makefile	modified	+2 −1
src/backend/catalog/sql_features.txt	modified	+25 −0
src/backend/catalog/system_views.sql	modified	+23 −1
src/backend/commands/alter.c	modified	+10 −1
src/backend/commands/foreigncmds.c	added	+1102 −0
src/backend/commands/Makefile	modified	+2 −2
src/backend/foreign/dummy/dummy_fdw.c	added	+24 −0
src/backend/foreign/dummy/Makefile	added	+27 −0
src/backend/foreign/foreign.c	added	+389 −0
src/backend/foreign/Makefile	added	+25 −0
src/backend/foreign/postgresql/Makefile	added	+27 −0
src/backend/foreign/postgresql/postgresql_fdw.c	added	+123 −0
src/backend/Makefile	modified	+2 −2
src/backend/nodes/copyfuncs.c	modified	+153 −1
src/backend/nodes/equalfuncs.c	modified	+133 −1
src/backend/nodes/makefuncs.c	modified	+14 −1
src/backend/parser/gram.y	modified	+374 −9
src/backend/parser/keywords.c	modified	+5 −1
src/backend/tcop/utility.c	modified	+100 −1
src/backend/utils/adt/acl.c	modified	+308 −1
src/backend/utils/cache/syscache.c	modified	+76 −1
src/bin/pg_dump/common.c	modified	+13 −1
src/bin/pg_dump/dumputils.c	modified	+5 −1
src/bin/pg_dump/pg_backup_archiver.c	modified	+10 −4
src/bin/pg_dump/pg_dump.c	modified	+389 −1
src/bin/pg_dump/pg_dump.h	modified	+25 −1
src/bin/pg_dump/pg_dump_sort.c	modified	+15 −1
src/bin/psql/command.c	modified	+18 −2
src/bin/psql/describe.c	modified	+154 −1
src/bin/psql/describe.h	modified	+10 −1
src/bin/psql/help.c	modified	+4 −1
src/bin/psql/tab-complete.c	modified	+119 −5
src/include/catalog/catversion.h	modified	+3 −3
src/include/catalog/dependency.h	modified	+4 −1
src/include/catalog/indexing.h	modified	+19 −1
src/include/catalog/pg_foreign_data_wrapper.h	added	+62 −0
src/include/catalog/pg_foreign_server.h	added	+65 −0
src/include/catalog/pg_proc.h	modified	+30 −1
src/include/catalog/pg_user_mapping.h	added	+58 −0
src/include/commands/defrem.h	modified	+17 −1
src/include/foreign/foreign.h	added	+101 −0
src/include/nodes/makefuncs.h	modified	+3 −1
src/include/nodes/nodes.h	modified	+11 −1
src/include/nodes/parsenodes.h	modified	+114 −2
src/include/utils/acl.h	modified	+12 −1
src/include/utils/builtins.h	modified	+13 −1
src/include/utils/syscache.h	modified	+8 −2
src/Makefile	modified	+2 −1
src/test/regress/expected/foreign_data.out	added	+1008 −0
src/test/regress/expected/rules.out	modified	+2 −1
src/test/regress/expected/sanity_check.out	modified	+4 −1
src/test/regress/parallel_schedule	modified	+2 −2
src/test/regress/serial_schedule	modified	+2 −1
src/test/regress/sql/foreign_data.sql	added	+396 −0