qwen/qwen3-coder-plus · d2_webhooks · rep 2

echo $SUPABASE_URL

https://<ref>.supabase.co

env | grep SUPABASE | head -10

SUPABASE_DB_PASSWORD=<redacted:SUPABASE_DB_PASSWORD>
SUPABASE_DB_URL=<redacted:SUPABASE_DB_URL>
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_SERVICE_ROLE_KEY=<redacted:SUPABASE_SERVICE_ROLE_KEY>
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted:SUPABASE_ANON_KEY>

psql "$SUPABASE_DB_URL" -c "SELECT table_schema, table_name FROM information_schema.tables WHERE table_type='BASE TABLE' AND table_schema = 'public';"

 table_schema |    table_name    
--------------+------------------
 public       | signups
 public       | webhook_receipts
(2 rows)

psql "$SUPABASE_DB_URL" -c "SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'signups' AND table_schema = 'public' ORDER BY ordinal_position;"

 column_name |        data_type         
-------------+--------------------------
 id          | bigint
 email       | text
 plan        | text
 created_at  | timestamp with time zone
(4 rows)

psql "$SUPABASE_DB_URL" -c "SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'webhook_receipts' AND table_schema = 'public' ORDER BY ordinal_position;"

 column_name |        data_type         
-------------+--------------------------
 id          | bigint
 received_at | timestamp with time zone
 payload     | jsonb
(3 rows)

psql "$SUPABASE_DB_URL" -c "CREATE EXTENSION IF NOT EXISTS pg_net;"

CREATE EXTENSION

psql "$SUPABASE_DB_URL" -c "
CREATE OR REPLACE FUNCTION send_signup_webhook()
RETURNS TRIGGER AS \$\$
DECLARE
  request_id bigint;
BEGIN
  SELECT net.http_post(
    url := '${SUPABASE_URL}/functions/v1/hook-recorder',
    headers := '{\"Authorization\":\"Bearer ${SUPABASE_SERVICE_ROLE_KEY}\", \"Content-Type\":\"application/json\"}'::jsonb,
    body := json_build_object('email', NEW.email, 'plan', NEW.plan)::text
  ) INTO request_id;

  RETURN NEW;
END;
\$\$ LANGUAGE plpgsql;
"

CREATE FUNCTION

psql "$SUPABASE_DB_URL" -c "
CREATE OR REPLACE TRIGGER trigger_send_signup_webhook
    AFTER INSERT ON public.signups
    FOR EACH ROW
    EXECUTE FUNCTION send_signup_webhook();
"

CREATE TRIGGER

psql "$SUPABASE_DB_URL" -c "INSERT INTO public.signups (email, plan) VALUES ('test@example.com', 'premium');"

ERROR:  function net.http_post(url => unknown, headers => jsonb, body => text) does not exist
LINE 1: SELECT net.http_post(
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT net.http_post(
    url := 'https://<ref>.supabase.co/functions/v1/hook-recorder',
    headers := '{"Authorization":"Bearer <redacted:SUPABASE_SERVICE_ROLE_KEY>", "Content-Type":"application/json"}'::jsonb,
    body := json_build_object('email', NEW.email, 'plan', NEW.plan)::text
  )
CONTEXT:  PL/pgSQL function send_signup_webhook() line 5 at SQL statement

psql "$SUPABASE_DB_URL" -c "SELECT proname, proargnames, proargtypes::regtype[] FROM pg_proc WHERE pronamespace = 'net'::$pg_namespace AND proname LIKE 'http%post%';"

ERROR:  syntax error at or near "AND"
LINE 1: ...gtype[] FROM pg_proc WHERE pronamespace = 'net':: AND pronam...
                                                             ^

psql "$SUPABASE_DB_URL" -c "SELECT proname, proargnames, proargtypes::regtype[] FROM pg_proc WHERE pronamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'net') AND proname LIKE 'http_post';"

  proname  |                  proargnames                   |              proargtypes               
-----------+------------------------------------------------+----------------------------------------
 http_post | {url,body,params,headers,timeout_milliseconds} | [0:4]={text,jsonb,jsonb,jsonb,integer}
(1 row)

psql "$SUPABASE_DB_URL" -c "
CREATE OR REPLACE FUNCTION send_signup_webhook()
RETURNS TRIGGER AS \$\$
DECLARE
  request_id bigint;
BEGIN
  SELECT net.http_post(
    url := '${SUPABASE_URL}/functions/v1/hook-recorder',
    headers := '{\"Authorization\":\"Bearer ${SUPABASE_SERVICE_ROLE_KEY}\", \"Content-Type\":\"application/json\"}',
    body := json_build_object('email', NEW.email, 'plan', NEW.plan)
  ) INTO request_id;

  RETURN NEW;
END;
\$\$ LANGUAGE plpgsql;
"

CREATE FUNCTION

psql "$SUPABASE_DB_URL" -c "INSERT INTO public.signups (email, plan) VALUES ('test@example.com', 'premium');"

ERROR:  function net.http_post(url => unknown, headers => unknown, body => json) does not exist
LINE 1: SELECT net.http_post(
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT net.http_post(
    url := 'https://<ref>.supabase.co/functions/v1/hook-recorder',
    headers := '{"Authorization":"Bearer <redacted:SUPABASE_SERVICE_ROLE_KEY>", "Content-Type":"application/json"}',
    body := json_build_object('email', NEW.email, 'plan', NEW.plan)
  )
CONTEXT:  PL/pgSQL function send_signup_webhook() line 5 at SQL statement

psql "$SUPABASE_DB_URL" -c "
CREATE OR REPLACE FUNCTION send_signup_webhook()
RETURNS TRIGGER AS \$\$
DECLARE
  request_id bigint;
BEGIN
  SELECT net.http_post(
    url := '${SUPABASE_URL}/functions/v1/hook-recorder',
    headers := '{\"Authorization\":\"Bearer ${SUPABASE_SERVICE_ROLE_KEY}\", \"Content-Type\":\"application/json\"}'::jsonb,
    body := json_build_object('email', NEW.email, 'plan', NEW.plan)::jsonb
  ) INTO request_id;

  RETURN NEW;
END;
\$\$ LANGUAGE plpgsql;
"

CREATE FUNCTION

psql "$SUPABASE_DB_URL" -c "INSERT INTO public.signups (email, plan) VALUES ('test@example.com', 'premium');"

INSERT 0 1

psql "$SUPABASE_DB_URL" -c "SELECT * FROM public.webhook_receipts;"

 id |          received_at          |                     payload                      
----+-------------------------------+--------------------------------------------------
  2 | 2026-07-26 02:14:16.710266+00 | {"plan": "premium", "email": "test@example.com"}
(1 row)

psql "$SUPABASE_DB_URL" -c "INSERT INTO public.signups (email, plan) VALUES ('john.doe@example.com', 'basic');"

INSERT 0 1

psql "$SUPABASE_DB_URL" -c "SELECT * FROM public.webhook_receipts ORDER BY received_at DESC LIMIT 2;"

 id |          received_at          |                      payload                       
----+-------------------------------+----------------------------------------------------
  3 | 2026-07-26 02:14:22.9124+00   | {"plan": "basic", "email": "john.doe@example.com"}
  2 | 2026-07-26 02:14:16.710266+00 | {"plan": "premium", "email": "test@example.com"}
(2 rows)