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:
/messages/by-id/15646-0d3caee9f6266f60@postgresql.org
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development