From: Joe Conway <mail@joeconway.com>
To: moshe@neadwerx.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: RESET does not work as described
Date: Thu, 27 Jun 2019 06:54:46 -0400
Message-ID: <699b5ed3-2af8-6e2f-4231-006016720582@joeconway.com> (raw)
In-Reply-To: <156156357970.28503.14020488601421765077@wrigleys.postgresql.org>
References: <156156357970.28503.14020488601421765077@wrigleys.postgresql.org>
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: mail@joeconway.com, moshe@neadwerx.com, pgsql-docs@lists.postgresql.org
Subject: Re: RESET does not work as described
In-Reply-To: <699b5ed3-2af8-6e2f-4231-006016720582@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox