function http_header(unknown, unknown) does not exist

[JakovGlavac]

Hi,
i'm trying to create a simple function that will call post request. But i'm getting an error function http_header(unknown, unknown) does not exist. I've found a post fixing simular issuse but it didnt help. I dont know if i'm doing somthing wrong?

CREATE OR REPLACE FUNCTION send_new_user_event()
RETURNS trigger AS $$
BEGIN

    SET search_path TO public, extensions; 

    SELECT *
    FROM http((
      'POST',
      'https://api.june.so/sdk/track',
      ARRAY[http_header('Authorization', 'Basic 123124')],
      'application/json',
      jsonb_build_object(           
        'userId', '12345',           
        'event', 'Signup',             
        'properties', jsonb_build_object(
            'raw_user_meta_data', '{"country": "US", "age": 25}'::jsonb 
        )
      )::text                       
    ));
    RETURN NEW;  
END;
$$ LANGUAGE plpgsql;

[GaryAustin1]

Did you install the http extension into the extensions schema?

Also normally the search path goes in the function parameters definition section like:

$$  language plpgsql 
     set search_path = extensions, storage, pg_temp;

But it may work in the plpgsql code, I've just not seen or done that.

[JakovGlavac]

I dont get where should i put search_path excacly in my query?

[GaryAustin1]

    ));
    RETURN NEW;  
END;
$$ LANGUAGE plpgsql set search_path = extensions,public;

As I said I do not know that you can't do it your way. The way I show (or in the beginning part of the function before $$) are the ways I've seen.

I take you have the extension enabled in extensions?

[GaryAustin1]

This is the code I use:

            select status from
                http((
                      'DELETE',
                      instance_url || '/storage/v1/object/' || bucket,
                      ARRAY[http_header('authorization','Bearer ' || service_role_key)],
                      'application/json',
                      file_body
                    )::http_request) into delete_status;  --not sure delete status is useful from storage-API in this case
            end if;

From https://github.com/GaryAustin1/supa-file-helper/blob/main/main.sql

[gevera]

This is the code I use:

            select status from
                http((
                      'DELETE',
                      instance_url || '/storage/v1/object/' || bucket,
                      ARRAY[http_header('authorization','Bearer ' || service_role_key)],
                      'application/json',
                      file_body
                    )::http_request) into delete_status;  --not sure delete status is useful from storage-API in this case
            end if;

From https://github.com/GaryAustin1/supa-file-helper/blob/main/main.sql

God bless you!