Supabase postgres function is not found on supabase js

Hi.

I have this function that when i use the rpc function of supabase returns me the following.


CREATE OR REPLACE FUNCTION close_advertisements (lat float, lng float)
    RETURNS SETOF public.advertisements
    LANGUAGE plpgsql
    AS $$
BEGIN
    RETURN query (
        SELECT
            *
        FROM
            advertisements
        WHERE
            ST_DWithin (geom, ST_SetSRID (ST_MakePoint (lng, lat), 4326), 10000));
END;
$$
SECURITY DEFINER SET search_path = extensions, public, pg_temp;


CREATE OR REPLACE FUNCTION close_advertisements (lat float, lng float)
    RETURNS SETOF public.advertisements
    LANGUAGE plpgsql
    AS $$
BEGIN
    RETURN query (
        SELECT
            *
        FROM
            advertisements
        WHERE
            ST_DWithin (geom, ST_SetSRID (ST_MakePoint (lng, lat), 4326), 10000));
END;
$$
SECURITY DEFINER SET search_path = extensions, public, pg_temp;

Error message:

"Could not find the public.close_advertisements() function or the public.close_advertisements function with a single unnamed json or jsonb parameter in the schema cache"

I added the security definer to try an make it visible but without success

Supabase•4y ago•

13 replies

Header

Supabase postgres function is not found on supabase js

Hi.

I have this function that when i use the rpc function of supabase returns me the following.


CREATE OR REPLACE FUNCTION close_advertisements (lat float, lng float)
    RETURNS SETOF public.advertisements
    LANGUAGE plpgsql
    AS $$
BEGIN
    RETURN query (
        SELECT
            *
        FROM
            advertisements
        WHERE
            ST_DWithin (geom, ST_SetSRID (ST_MakePoint (lng, lat), 4326), 10000));
END;
$$
SECURITY DEFINER SET search_path = extensions, public, pg_temp;


CREATE OR REPLACE FUNCTION close_advertisements (lat float, lng float)
    RETURNS SETOF public.advertisements
    LANGUAGE plpgsql
    AS $$
BEGIN
    RETURN query (
        SELECT
            *
        FROM
            advertisements
        WHERE
            ST_DWithin (geom, ST_SetSRID (ST_MakePoint (lng, lat), 4326), 10000));
END;
$$
SECURITY DEFINER SET search_path = extensions, public, pg_temp;

Supabase postgres function is not found on supabase js

Similar Threads

Supabase postgres function is not found on supabase js

Similar Threads

Similar Threads

Similar Threads