pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedRESET does not work as described
2+ messages / 2 participants
[nested] [flat]
* RESET does not work as described
@ 2019-06-26 15:39 PG Doc comments form <noreply@postgresql.org>
2019-06-27 10:54 ` Re: RESET does not work as described Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-06-26 15:39 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: moshe@neadwerx.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RESET does not work as described
2019-06-26 15:39 RESET does not work as described PG Doc comments form <noreply@postgresql.org>
@ 2019-06-27 10:54 ` Joe Conway <mail@joeconway.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Conway @ 2019-06-27 10:54 UTC (permalink / raw)
To: moshe@neadwerx.com; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-06-27 10:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-26 15:39 RESET does not work as described PG Doc comments form <noreply@postgresql.org>
2019-06-27 10:54 ` Joe Conway <mail@joeconway.com>
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