RLS on UPDATE `WITH CHECK` call function using new row data?

In the WITH CHECK part of an UPDATE when using RLS, how do I pass the incoming/new row data to a function? (or do I need to simply list every column?)
I tried

my_function(new)

my_function(new)

but get an error that "new is not a column".

my_function(*)

my_function(*)

also did not work.
My function is pretty simple (docs is the name of the table):

create or replace function public.my_function(docs) 
returns boolean as $$
begin
  return true;
end;
$$ language plpgsql security definer;

create or replace function public.my_function(docs) 
returns boolean as $$
begin
  return true;
end;
$$ language plpgsql security definer;

Supabase•4y ago•

7 replies

nickreed9888

RLS on UPDATE `WITH CHECK` call function using new row data?

In the WITH CHECK part of an UPDATE when using RLS, how do I pass the incoming/new row data to a function? (or do I need to simply list every column?)
I tried

my_function(new)

my_function(new)

but get an error that "new is not a column".

my_function(*)

my_function(*)

also did not work.
My function is pretty simple (docs is the name of the table):

create or replace function public.my_function(docs) 
returns boolean as $$
begin
  return true;
end;
$$ language plpgsql security definer;

create or replace function public.my_function(docs) 
returns boolean as $$
begin
  return true;
end;
$$ language plpgsql security definer;

RLS on UPDATE `WITH CHECK` call function using new row data?

Similar Threads

RLS on UPDATE `WITH CHECK` call function using new row data?

Similar Threads

Similar Threads

Similar Threads