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