looks like newObject doesn't have a value for

id

?

It does, I fixed it by

deleting

the target table and assinging the

Is Identity

property of

id

column primary-key checkbox to

checked

There's far too many bugs and issues with Supabase

Hello, why am I receiving an empty array with just let { data: categories, error } = await supabase .from('categories') .select('*')

That error in your screenshot was one that the Postgres server itself raised, and would happen even if you were going direct to a non-supabase Postgres instance

Is there a roadmap or release blog?

Is there anyway to reset a password WITHOUT using the built in reset password process? I'd like to create my own OTP and send it to the user through our verified email address and post that as the user's password.

I fixed, but there's a swarm of other issues that slow our team development... 😞

This just appears out of no where all the time, for no reason;

Pasting excel/google sheets data to generate a table, does not work just for columns, with no data... (gives the same error)

The table columns do not allow for changing the

type

of column (ie: varchar to text or anything else...) Showing this error, making us delete a table and create a new one correctly...

Hey everybody! Quick question. I'm trying to delete an entry from my

categories

table, however it isn't deleting due to a foreign key constraint. I have a join table named

category_items

, which is where it's failing. How can I alter the table to allow for a

ON DELETE CASCADE

? I'm looking to automatically delete entries from

category_items

whenever attempting to delete an entry from

categories

.

@User can you create a thread with the issues you are having please? also if they are related to the platform itself you can use the feedback widget in the dashboard to report them along with the steps it took you to get the errors.

Roadmap or release blog

This would be a good feature to have, maybe raise it in #867348150741237790

Why am I receiving an empty array when I do a select

alter table to allow CASCADE DELETE

How would one right a policy that says a user can query everything from a table if their

public.profiles

field

role

is set to

"admin"

??

Or is that not an option since that would require including another table in the policy?

Is it possible to access Supabase storage S3 directly, just like Database?

Is it possible to determine if the user is signing in for the first time? For example with email/password-signup, and after the user is being redirected to the app after confirming their email?

if you have a

public.users

table as well you can check the

uid

against that table

yes, I have a public users-table, but don't know how that would help me? The uuid will be there independent if it's the first or the fourth time the users is logging in!? Correct me if I'm wrong.

If you do not have a trigger/function set up, then the

public.users

table will not have a new line until you insert one. So the

uid

of the row in

auth.users

will match the foreign key of

user_id

in

public.users

. So they should be unique and not repeat. Once a user registers you can redirect them to say

/profiles

and from there query for their

session.user.id

in the

public.users

table and if it does not exist, this is a new user. Of course this is just one way and I am sure there are other, more effective ways.

I'm new to this, how could I go about restricting what sort of characters are allowed to go into one of my text columns? For example I want a username column with no whitespace, only certain characters, and only a certain maximum length

how could i say that someone with the field

role

with value

admin

can select all rows from the that table?

I thought i could make the policy like this but i must not be understanding correctly?

profiles.role() = admin

hi! My supabase server is down.. where do I can help?

I restarted my app several times