Thread: RESET does not work as described
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/bug-reporting.html Description: The initial value returned when current_setting() is passed an unset parameter is '<NULL>'. After a SET and a RESET, the value returned by current_setting() is ''. This causes an invalid cast when the value is cast to an integer, as it is expected to be. Tested on Postgres 10 in Linux.
On 6/26/19 11:39 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/bug-reporting.html > Description: > > The initial value returned when current_setting() is passed an unset > parameter is '<NULL>'. > After a SET and a RESET, the value returned by current_setting() is ''. > This causes an invalid cast when the value is cast to an integer, as it is > expected to be. > Tested on Postgres 10 in Linux. This has been discussed fairly recently but the discussion died out: https://www.postgresql.org/message-id/flat/15646-0d3caee9f6266f60%40postgresql.org Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development