Supabase Trigger Fails with 'invalid input syntax for type uuid' on User Sign-Up

[coode-sensei]

I’m using Supabase to handle user authentication and have a database trigger set up to populate the users table when a new user signs up. Here’s the setup:

Supabase Sign-Up Code:

const { error } = await supabase.auth.signUp({
    email,
    password,
    options: {
    data: {
      id: coreUser.id, // UUID
      full_name: name,
      utm_params: utmParams,
      referral_id: referralID,
      },
     },
   });

The id field is a valid UUID, and I’ve added a check to ensure it matches the UUID format before making the signUp call:

if (!/^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$/.test(coreUser.id)) {
  throw new Error("Invalid UUID format for coreUser.id");
}

Trigger Function:

I have a PostgreSQL trigger that inserts user data into the users table upon sign-up:

begin
  insert into public.users (id, email, full_name, avatar_url, executions, utm_params, referral_id, created_at, updated_at)
  values (
    new.raw_user_meta_data->>'id'::uuid,
    new.email,
    new.raw_user_meta_data->>'full_name',
    new.raw_user_meta_data->>'avatar_url',
    250,
    COALESCE(new.raw_user_meta_data->'utm_params', '{}'::jsonb),
    new.raw_user_meta_data->>'referral_id',
    now(),
    now()
  );
  return new;
end;

Error:

When a user signs up, Supabase throws the following error:

{
  "component": "api",
  "error": "failed to close prepared statement: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02): ERROR: invalid input syntax for type uuid: \"id\" (SQLSTATE 22P02)",
  "level": "error",
  "method": "POST",
  "msg": "500: Database error saving new user",
  "path": "/signup",
  ...
}

My user's table id type is UUID.

Does someone know why it's causing this error?

Any help would be greatly appreciated Thank you.

[GaryAustin1]

Probably: (new.raw_user_meta_data->>'id')::uuid
Also you can log out your incoming values to the Postgres log with raise log 'new = %',new;.