create table user_roles (
  id bigint generated by default as identity primary key,
  user_id uuid references auth.users not null,
  role_definition_id bigint references role_definitions (id)
);

Why does auth.users correctly reference a foreign key but if I do role_definitions.id it says schema permissions doesn't exist?

Hey! Is the provider token the token that is issued by the provider?

I have a question regarding authentification with supabase goTrue service. I need to support a third party provider which offers oAuth2 and OpenID connect. Unfortunately it is not yet directly supported by supabase. What do I need to do to integrate an unsupported auth provider in my supabase project? Firebase does support a general oAuth2 authentication flow but I would prefer not to go back to Firebase. Related github issue (not by me): https://github.com/supabase/gotrue/issues/159 If I create a PR (with tests 😉 ) to add a rather niche third party auth provider ORCID (big in research community), will it get merged?

I'm trying to get query results aggregated into their own field because Zapier doesn't seem to handle an array as a response body... For this query

curl 'https://ixlqpcigbdlbmfnvzxtw.supabase.co/rest/v1/buyers?select=json_agg%28buyers%29'

I get

{"hint":"If a new foreign key between these entities was created in the database, try reloading the schema cache.","message":"Could not find a relationship between buyers and json_agg in the schema cache"}

and am wondering what I'm doing wrong. Works great in the sql editor. Many thanks!

Okay so now I'm just trying to setup the PostgreSQL app in Zapier vs going through the REST endpoint but I get this:

Trying to setup this no-code thing for someone and I'm about to just code it 😄

Would have been done by now.

I can successfully connect to my Supabase db via another Postgres client.

Foreign keys errir

Hey! I have this query:

id,
            chat_id,
            members (
              id,
              nickname,
              auth.users (
                raw_user_meta_data
              )
            ),
            created_at,
            edited_at

but get a 400 back with

json
{
   "hint":"If a new foreign key between these entities was created in the database, try reloading the schema cache.",
   "message":"Could not find a relationship between members and auth in the schema cache"
}

Even though i do have a forign key between members and auth.users

Querying auth.users

I'm in this boat. Were you able to find a solution for this? I've tried to research but still coming up empty.

Hey Folks! Is it possible to add new columns to the auth user table in supabase? Ideally, i'd like to add a column for the users role.

Modifying auth.users

Unfortunately I ended up updating the name on the server side which has full access compared to user's browser. But I actually didn't do the proper authentication on the server side when the browser asks it to update the name. So I'm not so comfortable with it 🤞

I'm trying to create a cron job that checks my database row and if its lesser than the current time delete it. I can't find the function called

Now()

though

Nvm apparently

CURRENT_TIME

works

Is it possible to add authorized domains to supabase which are then recognized when sending authentication emails? Correct me if im wrong but i think its currently possible for anyone on the internet to copy my supabase_url and supabase_key, which i passed to the createClient function, and then send for example magic links to random emails in the name of my supabase project.

Hi devs, can someone explain to me what the transfer limit refers to?

It relates to object storage, as that's where it appears in the table

I have generated types using openapi-typescript as in the docs, but how do I use it on joins? because it only has definitions for each table and not including foreign key relationships

im free tomorrow anyone want help?

i get this error when i try to delete rows from a table

it removes the rows in the UI

but when i press refresh, the rows come back

seems like my problem is similar to this

so i just use sql to delete records?

Yes

is it possible to view the public schema on the dashboard? my queries are now returning "permission denied for schema public" and im not sure why

I'm going to guess you turned on row level security and you didn't have it on before