How to enable hints in the api?

[S0KL0dev]

I really want to know how to in anyway improve the error/warning messages

[1] Error in RPC call: {
[1] code: '42703',
[1] details: null,
[1] hint: null,
[1] message: 'column "id" does not exist'
[1] }

cause i have checked literally every piece of code i have and there is 0 issues, but it keeps giving me this **** .

[GaryAustin1]

The message seems pretty clear that you are calling a column in your code and it does not exist.
Maybe show some code and table involved?
The Postgres log might have more info.
Not double quoting capital letters in Postgres names of things sometimes does this.

[S0KL0dev]

create or replace function approve_client_request(request_id uuid)
returns jsonb language plpgsql as $$
declare
    request_data record;
    existing_data record;
begin
    -- Fetch the request data for the client
    select id, name, email, phone 
    into request_data 
    from new_clients."NewClients" 
    where id = request_id 
    limit 1;

    if not found then
        return jsonb_build_object('error', 'Request form not found');
    end if;

    -- Check if the data already exists in the target table
    select id, name, email, phone 
    into existing_data 
    from "Clients" 
    where id = request_data.id 
    limit 1;

    if found then
        return jsonb_build_object('error', 'Data already exists in the target table');
    end if;

    -- Insert the data into the Clients table
    insert into "Clients" (id, name, email, phone)
    values (request_data.id, request_data.name, request_data.email, request_data.phone);

    -- Update the account type in the auth.users table
    update auth.users
    set raw_user_meta_data = jsonb_set(raw_user_meta_data, '{account_type}', '"client"')
    where raw_user_meta_data->>'account_type' = 'client_pending'
      and id = request_data.id;

    -- Delete the request from the new_clients."NewClients" table
    delete from new_clients."NewClients" 
    where id = request_id;

    -- Return success message
    return jsonb_build_object('message', 'Client request approved and data inserted successfully');
end;
$$;

is the code that causing those issues
both Client and New Client tables have column id and both are uuid

[S0KL0dev]

i tried wrapping everthing in " " but it didnt help

[GaryAustin1]

Postgres log have any info on the error?
Also you can use raise log 'request_data = %',request_data; to check steps. That will be in the Postgres log also.

[S0KL0dev]

Thanks that helped to fix it.
I added the "" but (as always magically) it didnt work, i removed and redid again that changed the error log to a trigger, then i "fixed" (commented out a part of it) it. And now this works.