Add an optional missing_ok argument to SQL function current_setting().
Tom Lane <tgl@sss.pgh.pa.us>
Add an optional missing_ok argument to SQL function current_setting(). This allows convenient checking for existence of a GUC from SQL, which is particularly useful when dealing with custom variables. David Christensen, reviewed by Jeevan Chalke
Files
| Path | Change | +/− |
|---|---|---|
| contrib/tsearch2/tsearch2.c | modified | +1 −1 |
| doc/src/sgml/func.sgml | modified | +6 −1 |
| src/backend/utils/misc/guc.c | modified | +42 −11 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +4 −2 |
| src/include/utils/builtins.h | modified | +1 −0 |
| src/include/utils/guc.h | modified | +2 −1 |
| src/test/regress/expected/guc.out | modified | +31 −0 |
| src/test/regress/sql/guc.sql | modified | +13 −0 |