Add new to_reg* functions for error-free OID lookups.
Robert Haas <rhaas@postgresql.org>
Add new to_reg* functions for error-free OID lookups. These functions won't throw an error if the object doesn't exist, or if (for functions and operators) there's more than one matching object. Yugo Nagata and Nozomi Anzai, reviewed by Amit Khandekar, Marti Raudsepp, Amit Kapila, and me.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +48 −0 |
| src/backend/catalog/namespace.c | modified | +4 −2 |
| src/backend/parser/parse_oper.c | modified | +3 −3 |
| src/backend/parser/parse_type.c | modified | +27 −2 |
| src/backend/utils/adt/regproc.c | modified | +104 −4 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/namespace.h | modified | +2 −1 |
| src/include/catalog/pg_proc.h | modified | +8 −0 |
| src/include/parser/parse_type.h | modified | +1 −1 |
| src/include/utils/builtins.h | modified | +4 −0 |
| src/pl/plperl/plperl.c | modified | +1 −1 |
| src/pl/plpgsql/src/pl_gram.y | modified | +1 −1 |
| src/pl/plpython/plpy_spi.c | modified | +1 −1 |
| src/pl/tcl/pltcl.c | modified | +1 −1 |
| src/test/regress/expected/regproc.out | added | +188 −0 |
| src/test/regress/parallel_schedule | modified | +1 −1 |
| src/test/regress/serial_schedule | modified | +1 −0 |
| src/test/regress/sql/regproc.sql | added | +61 −0 |