does anybody have an idea? 🥺

I was just looking at this on the discussions.

I can't seem to delete a user, :/ the only foreign key it had was to the profiles table, but when I deleted everything in profiles, it still couldn't delete users. Is there a way for me to forcefully delete it?

There is a constraint on the

objects

table it seems

@User you probably have uploaded a file to storage under a user

This is a bug type thing that i ran into and others have as well.

The solution is to add an on delete set null to the objects table.

how do I use both phone and email verification with supabase auth?

🚨🚨🚨 I need to upgrade my account 🚨🚨🚨

BIG data coming through. watch out. someone plz take my money

Pro plan: Done through the dashboard PAYG plan: There's a 'contact us' link on the pricing page (https://supabase.io/pricing)

Is publication enabled on all tables when doing supabase init to create a local version? I am using my create script I've been using on supabase.io and getting this error

publication "supabase_realtime" is defined as FOR ALL TABLES

Should i turn it off here to get the same behavior of supabase.io?

I can't seem to find the command to set it to specific tables prior to making tables.

sql
create publication publication_name 
for table table_one, table_two;

You can't create a publication on a table which doesn't exist

Right, I just wanted to turn off FOR ALL TABLES so I can just then run my create script.

Looks like only way I can find is create tables, then set it to the specific tables

then just recreate it at the end of the tables?

Yep. Open the query with

begin;

and close with

commit;

(i.e. a single transaction) to ensure that the drop only happens if the create succeeds

Hi everyone. This could be a reach but I'm looking for someone who can help setup and build the back-end for my Nuxt application using Supabase auth and storage. Paid opportunity for a senior full stack developer with experience in Vue/Nuxt.js, Node.js and Supabase. Please DM me if you're interested.

Looks like I have a backup in progress that appears to be "stuck", it also happens to be the one I want to restore from 😢 . Any ideas as to what could be going on?

I have no clue why this is but use the feedback widget in the dashboard to ask the Supabase team about this or email beta@supabase.io

imma check in on this

thats the problem or bug? i dont have any table named objects

ops nevermind, it just deleted right now. O.o I deleted all the avatars from the buckets, I guess that made it go?

The table its referring to is in the

storage

schema, its

storage.objects

woah okay so its on another schema, thanks! it cleared up all of my confusions

containedBy now doesn't work

I have no idea what could have changed.