Re: ISN extension - wrong volatility level for isn_weak() function

Daniel Gustafsson <daniel@yesql.se>

From: Daniel Gustafsson <daniel@yesql.se>

To: Viktor Holmberg <v@viktorh.net>

Cc: pgsql-bugs@lists.postgresql.org

Date: 2025-03-14T14:09:23Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

contrib/isn: Make weak mode a GUC setting, and fix related functions.
- 44890442398c 18.0 landed
Update contrib/seg for new scalarlesel/scalargesel selectivity functions.
- 44ba29206449 11.0 cited

> On 14 Mar 2025, at 14:58, Viktor Holmberg <v@viktorh.net> wrote:
> 
> Yes, you’re right Daniel. I ended up settling on the following workaround:
> 
> ALTER FUNCTION isn_weak() VOLATILE;
> ALTER FUNCTION public.isn_weak(boolean) VOLATILE;

Thanks for confirming.  This would need a backpatch into all supported versions
it seems.

--
Daniel Gustafsson