pgsql: Add pg_identify_object_as_address

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Add pg_identify_object_as_address
Дата
Msg-id E1Y61kX-0001C5-3K@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Add pg_identify_object_as_address

This function returns object type and objname/objargs arrays, which can
be passed to pg_get_object_address.  This is especially useful because
the textual representation can be copied to a remote server in order to
obtain the corresponding OID-based address.  In essence, this function
is the inverse of recently added pg_get_object_address().

Catalog version bumped due to the addition of the new function.

Also add docs to pg_get_object_address.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/a676201490c8113b4692562126c77a29dfd8dac1

Modified Files
--------------
doc/src/sgml/func.sgml                       |  149 ++++++++++----
src/backend/catalog/objectaddress.c          |  274 ++++++++++++++++++++++++--
src/backend/utils/adt/regproc.c              |   60 ++++++
src/include/catalog/catversion.h             |    2 +-
src/include/catalog/objectaddress.h          |    3 +
src/include/catalog/pg_proc.h                |    3 +
src/include/utils/builtins.h                 |    5 +
src/test/regress/expected/object_address.out |   85 ++++----
src/test/regress/sql/object_address.sql      |   11 +-
9 files changed, 485 insertions(+), 107 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: pgsql: Use TypeName to represent type names in certain commands
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: pg_event_trigger_dropped_objects: Add name/args output columns