@User they are working on a fix: https://status.supabase.com/incidents/wfw0dqkpfxjg

Noice! thanks again

I can't update expiration for the JWT on /auth/settings page in the supabase dashbord. The error message is:

Error on submitting

{
  "instancePath": "",
  "schemaPath": "#/required",
  "keyword": "required",
  "params": {
    "missingProperty": "JWT_EXP"
  },
  "message": "must have required property 'JWT_EXP'"
}

JWT expiration updating

Hi guys, I need a little help here because I am new to supabase and I really can't figure out how this one works. So I am trying to work with RLS and make a policy so I can fetch my data from a table. so my table structure is User - table1 - table2 I already got it to work so that i can get data from table 1 when I am logged in as a specific user, but I now have to get data from table one which belongs to data from table2 which belongs to a specific user. a 1to* relation and I really can't figure out how this works It may seem as a simple problem, but I can really not find out how it works so id apreciate any help I could get. Thanks!

I'm new to Supabase; I read the docs about RLS, but still not sure with creating policies. I created a table named Profiles where I store additionnal informations about users. One of the columns is call Permission, where 9 is admin and 1 is website member. I want admin to be able to connect to the dashboard, but not members. For now, I make signIn request, await session.user.id, and then look for this id in my Profiles table to see if user has permission, but it's all client side, is there a better way? Also, how do I create the Policies that would allow only user with admin permission to insert or update content in database? Thanks

Insert Boolean in Function

Hi, I have a question regarding the functions. There is scenario that I want to update one table(EX: profile), and after that I want to delete one row in another table(todo). Both table have no reference to each other. Is there a way to do it in function triggers ? Like when I call update profile in code can pass some arguments which is not belongs to update profile logic, but can be used in the function to delete one row in todo.(pass todo id) or I have to update profile and delete one row in todo table from code ? thanks

We have different provider. What data are guranteed and what extra we get from those providers. HOw to sync them with your profiles table. It is so difficult

trigger function and scope

Hi, coming back to my project after a long vacation and it disappeared, what gives? Anyone else experience this?

Hi, need help with this function, it has been triggered, but the points is not updated. Any idea ?

ts
begin
  update profile
  set points = points + 2
  where id::text = new.kid_id;
  return new;
end;

RLS?

Cross posted from js since I think this is likely more general: Ok, a bit more testing; Realtime and RLS don't seem to be working together at the moment. Have simplified Expo project with client supabase-js 1.29.1. I've got a brand new supabase hosted database project running pg 14.1. If I subscribe to updates for a new table 'test' I get them just fine. If I enable RLS on 'test' even if the policy is set to simply return true for all operations I get no updates. Is there anywhere I can dig to debug further? Not seeing any Realtime logs in the dashboard

I am building a local development environment for Supabase. According to the link below, Studio only supports Table & SQL editors, Database management and API documentation. https://github.com/supabase/supabase/tree/master/studio#whats-included However, I would like to use Authentication with Google as external OAuth providers in my local environment. Does anyone have any good ideas?

Hello, can someone help me? Why when i use supabase in docker i can`t create a project, there is just no button, but it is in web version?

self hosted oauth

Is there a way to enable e-mail confirmation but PREVENT Supabase from sending the confirmation emails automatically? I want to send those e-mails myself using genrateLink() since I want to use a template from my custom SMTP provider and NOT use the templates in the Dashboard

hey guys, i'm trying to create an app where an admin can invite other users to their group page from the UI. i see that there's a function https://supabase.com/docs/reference/javascript/auth-api-inviteuserbyemail inviteuserbyemail but i don't understand the note "This function should only be called on a server. Never expose your service_role key in the browser."

where should this be called? what is meant by "server" here? or is there a better way to do this?

Using inviteUserByEmail

Hello, I have a small question regarding the CREATE statement generated by the Supabase studio.

sql
CREATE TABLE IF NOT EXISTS public.locations
(
    id uuid NOT NULL DEFAULT uuid_generate_v4(),
    name text COLLATE pg_catalog."default" NOT NULL,
...

What is behind the

pg_catalog."default"

?

SHOW lc_collate;

gives me

C.UTF8

. What is the impact on a multilingual app? Is UTF8 enough for most european languages?

UTF-8 works well with European languages, and should be enough for most languages

wondering if anyone's faced a similar issue

I want to replace a file in a bucket storage. The file is the UID name of user + 'jpg'. I tried multiple solutions with upload and update. I received errors 400 with update and 42501 with upload (upsert): new row violates row-level security policy (USING expression) for table \"objects\" So it's probably a problem with RLS, but I don't know how to correct this and make it work... Can someone help?

If the bucket is not public, then you need to set storage policies for that bucket for sure. You do that in the Storage part of the UI.

I don't think the bucket is public. What is the difference between public and private?

Public for file where anonymous user can interact and private only if authenticated?