Yea I meant one column, in a row

You can check out this post: https://supabase.io/docs/reference/javascript/update

Relational databases are not intended to work this way, however you can do it, look at this thread and you should find an answer there https://github.com/supabase/supabase/discussions/1570

ok thanks guys!

thanks man, this link helped me. I got it working now.

Hello,

Does anyone know how to delcare and use a variable in a trigger - this is erroring:

create or replace function public.create_project_on_new_user() 
returns trigger as $$
declare
  new_project_id uuid;
begin
  new_project_id = uuid_generate_v4();
  -- insert into public.profiles (id, project) values (new.id, ''); 
  -- insert into public.projects (id, type, name) values (new_project_id, 'PERSONAL', '...');
  -- insert into public.profiles_projects (profile_id, project_id) values (new.id, new_project_id);
  return new;
end;
$$ language plpgsql security definer;

The inserts are commented out for now, but the declaration of a variable just fails - can't see any logs as the client throws a generic error

Hello Everyone - Just to follow up on my earlier message, does anyone have any insight?

Hello guys, I'm having issues with multitenant configuration. Trying the example on the docs

Any tips?

Is your

auth.users.id

definitely a

uuid

type (it is by default, but better to check)? You should be able to run

SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'users' AND table_schema = 'auth'

to check

even if I specify the auth.user.sid

That's really strange. If you run the same command from something like pgadmin, or even the Supabase SQL dashboard (unless this is the dashboard, in which case try pgAdmin or similar), does it still show the same error?

I'm running on the Sapabase SQL dashboard.

Tried on DataGrip as well but I receive permission.denied for table users. (however I can create tables that doesn't do references between postgres databases)

the credentials are correct and I can create the connection

I know that some older projects had the Postgres user as a superadmin of the DB and could do anything, but somewhere along the way, it got changed so it's not superadmin. It might be worth opening a bug report in the repo, or a discussion so that other people can add their thoughts. I've just tested your example query on a recently created (~3 days ago) project, and it didn't throw any errors for me 🤔

found the issue. Went hard mode.

Query by query. It was a mistake in a specific query. The id comparison of the policy was wrong

thanks for the tips @User

How do I refresh the postgrest schema? updated some columns and it's not showing up in the generated openapi

can you try this

nvm, found

oh lol

there's a button, thanks for that!

does that restart the entire db or just refresh the postgrest schema?

it will be entire db. So if the SQL works, then you should use that

Is there any recommend way to structure a multi lingual blog architecture on postgress/ supabase.

not so experienced with blogs, but maybe something like table blogs -> id, date, author content table -> locale (en_en), blog_body, blogId just an idea tho. then u could do something like select content.stuff, blog.stuff from content inner join blogs on id = blogId where locale = user_locale