Nick
01/07/2022, 2:01 PMNick
01/07/2022, 2:25 PMgen_random_bytes
inside the body of my function, and when my function executes, gen_random_bytes
is not foundNick
01/07/2022, 2:25 PMsecurity definer set search_path = public
in my function as in the guide, does that obscure the lookup for gen_random_bytes
?Nick
01/07/2022, 2:25 PMgen_random_bytes
correctly?Nick
01/07/2022, 2:41 PMpublic
, no dice: function public.gen_random_bytes(integer) does not exist
Scott P
01/07/2022, 3:28 PMextensions
schema, rather than public
or auth
Scott P
01/07/2022, 3:29 PMNick
01/07/2022, 4:18 PMNick
01/07/2022, 4:18 PMNick
01/07/2022, 4:24 PMextensions.gen_random_bytes
or set the search_path in security definer to include extensionsNick
01/07/2022, 4:24 PM