Hi, i am tries check user is super_admin in policies using:

(auth.uid() IN ( SELECT u.id
   FROM auth.users u
  WHERE u.is_super_admin))

but i am getting this error:

{"hint":null,"details":null,"code":"42501","message":"permission denied for table users"}

how i do check user is super_admin in policies?

General users will not have access to the auth schema. You could use a security definer function to do the select on auth.users. I can't comment on if that is_super_admin is meaningful as I've never seen it set in my hosted system.

Hello 👋 ! I am messing around with testing functions, but am having trouble getting a response and I am unsure why.

Hello! Im running into an issue when using Realtime Supabase. When I use a channel topic

realtime:*

Im able to get all live updates from my db but when i use

realtime:public

the listener closes and doesn't send any updates/inserts to the client. I looked at all of my tables in supbase and all of them have a

public

schema and have been replicated. Im not sure why the realtime sockets arent returning data. Has anyone faced this before? Thanks

Hello! 🖖 Is anyone else having all of their API requests time out? Nothing changed and we went from having hundreds of thousands of requests respond just fine today to nothing at all resolving. Using supabase-js if that helps.

Hello, could someone help me understand what is tenant ID in storage-api

is it possible to create multiple projects in a local development environment ?

never mind 😄

> mattaye — Today at 4:51 PM > Hello again. My database is made up of a schema.sql that seems to have been imported magically when deploying to vercel using this starter project (https://github.com/vercel/nextjs-subscription-payments), and files i have created in the sql editor as i've played around with Supabase. I would like to wipe my db and start again, using a migration tool as it feels a bit of a mess and i want to verify that i can spin up a new db for production at a later date. > > What is the best way to reset to zero ready to run my newly organised migrations? Restarting the database keeps tables and data. Thanks Hi Mattaye Please use the right channel when asking, thanks you!

Ah will do , thanks Olyno. Any thoughts on the above?

If you're looking to make migrations, you should use psql, and connect to Supabase's postgres database, this is probably the best way

I'm not sure if i got your question right, don't hesitate to tell me if i didn't 😅

Thanks for your reply. So its a newbie question, but how do i wipe my supabase instance (remove all tables, procedures , data etc) and run the migrations again without deleting the project?

I gues sthe best way to wipe your supabase instance is simply to remove the project directly, and recreate it. Or you could try with ``pg_dump``: https://stackoverflow.com/a/2089668/8845770

I going to try Supabase for authentication and database in a React budgeting app, suggest me some good resources to learn about it :-)

Hi all. New to the channel, sorry if the question is dumb. Starting out with Supabase; I've looked into the docs but I can't find it anywhere: how can I edit the error message text that is displayed by default if the user, when signing up, enter a password that doesn't match the requirements (for example it's too short)? By default is in English, but I'd want it to be in Italian. Thank you very much for the help.

Translations in Supabase UI

Hey hey people, I just tried out Supabase auth with the Discord provider and I noticed that the user meta data (username, image) isn't saved. Is there a way to access this data with triggers and save them in another table?

Unable to log into Supabase after verifying emails. I'm waiting it out now, but is this normal?

Nope, try to clear your browser cache and try again

Is it possible to export a projects structure?

I have users from different location. Need to query based on users nearby. Any easy or recommended way to do it. Using nextjs

Hi all, i have an expo app paired with google signin on supabase, after a successfull supabase signin, onAuthStateChanged doesnot trigger in production . The redirect is working fine and onAuthStateChanged get fired on development mode. I'm fairly new to supabase, any help is much appreciated.

i got something similar today, is your problem fixed?

Hi, for HTTP RESTful functions how are we to add custom headers to the request e.g.

http_post

doesn't seem to allow this?

If you mean this: https://supabase.com/docs/guides/database/extensions/http then you have to use http as the function and setup all the info including any headers you want. http_post is just a short cut for simple stuff. Here is the extension page https://github.com/pramsey/pgsql-http

Still hasn't been resolved after sending an email to support. Is there any chance I can escalate this in some other way? 😅

@User / @User / @User sorry to disturb you guys, but could you help? I don't mind waiting for my account access, but rn my app itself is down (it uses Supabase APIs to render the UI)

Hey @User , Sorry to hear about the issues with login. I'm on it! Before we proceed could I trouble you to briefly describe what you've tried so far?