Re: RESET does not work as described
Joe Conway <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
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
signature.asc
(application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEg14x9eymXoJyHrH+N/L3QzX32GUFAl0UoHYACgkQN/L3QzX3 2GUeTw//cnmcHY48BtCrv4KZqilz8GFhZOMRy7BxSddlC1JRp/lx7n7VN+c+wR1I T/vwwY8ztskbX2sGP9Up+WIt6M0DpBjQdaPEVo4o6Nx3/objIBxQWhzgQuWZOF4G FhOutlRxMOb5EjCUvSFidM6zDl/sohaTGLOKvWlMtlWyrDJY3bTyXWQFeIS6VI/N CR/be35SpBixPShyJDDSwO4ap3lzxODbz6eK0m6z+y51pPD1HqsMGWhaT1lZ1J8j vMctJy4/xNFIfJy6DCcaoXMfmrAnvuhlZJOuv0FrpP1SMKRbqsjmc81X02cwwAwO MplxmJnScpXkmRR59XQEZi+bMFPWPBjciGz0l/tJvEZxWaM2Ra+ECIa1M5VqosXh cIi0opR3bhruvIOB2BeoBSBn25iCyeEGA74pPq6jwqplYgT/AZcQgFv6DLzjEcLX hvpRWPXR4iRdgxy18Es6XzwlG3GAcTEh9XF8qGSfk2ASAntYUwnp5P5FRPqq0c4S LQC39eqsLYxDNE018SyJKfIH5hq3WzYQeBOSDZOoYLaB4d2jczAOAPdPSxv7UrPh VHS6CN5YDTfCao6nZvXAEbObrLk7iGfJOsQ/6A/ZWtFXTRXPHQiojKU6D8FNRODC /mfj9eudjD5n/4njkM7+q+sxBiY2zJKrgx/SC+gPM7+LRgWQlxI= =bzVH -----END PGP SIGNATURE-----