Add pg_identify_object_as_address
Alvaro Herrera <alvherre@alvh.no-ip.org>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +106 −43 |
| src/backend/catalog/objectaddress.c | modified | +254 −20 |
| src/backend/utils/adt/regproc.c | modified | +60 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/objectaddress.h | modified | +3 −0 |
| src/include/catalog/pg_proc.h | modified | +3 −0 |
| src/include/utils/builtins.h | modified | +5 −0 |
| src/test/regress/expected/object_address.out | modified | +45 −40 |
| src/test/regress/sql/object_address.sql | modified | +8 −3 |