Does anyone know if you're able to set enum values in supabase? i'm unfamiliar with postgres, and i've been using the GUI mostly for creating rows

Hi, I am trying to add vercel integration via vercel.com and app.supabase.io tells me 'Retrieve vercel token failed'. Does anyone experience the same?

the same happens to me

yea, that's where I've been... thanks @User

Does anyone know how to reload the schema cache? I'm trying to run a SQL query that I made (increment) but I'm getting this error..

"If a new function was created in the database with this name and parameters, try reloading the schema cache."

EDIT: oh it's cause i need to run the query first it seems. but I get a

relation "posts" does not exist

error even though I have a table named posts. EDIT2: looks like i needed to name my table with a lowercase letter. it was called Posts and I changed it to posts and now it's working 👍 EDIT3: or maybe not.. RLS seems to be blocking it, any ideas..?

on 3 you don't give much info on what your function is doing, but you probably need security definer END; $$ LANGUAGE plpgsql SECURITY DEFINER which does not use RLS of the user

Ohh okay thank you! I’m using the incrementer template fyi

hello, is there any documentations on setting up LTREE with supabase?

LTREE with supabase?

I have a

codes

table with an

account_id

foreign key linking to the user's authenticated id. I'm trying to create an INSERT policy that allows users to create new codes with their own account ID but no one else's Replacing this policy with

true

allows the operation to work, but with this filter on I can't get any to pass and I'm not sure what I'm doing wrong

Got an error while trying to delete an user from

Authentication

tab,

Deleting user failed: update or delete on table "users" violates foreign key constraint "objects_owner_fkey" on table "objects"

Anyone here implemented a signup email flow with auth? I want to know when a user signs up so I can add them to an email marketing tool. I looked at Triggers but it doesn't show premade tables like users. How do I go about setting up triggers for the users table? Apologies if this has been asked before.

I think one of the rows in your objects table has the user id you're trying to delete. you have to delete that row first before you can delete the user.

Yeah it does but i'm not linked any of them

i deleted all entries but still same

still can't find a way out

Can you post some screenshots? I tested it just now and it works.

Tried some SQL queries still wont work

I meant screenshots of your tables from table editor

ahah

Sorry

pretty much every table is same, empty

Is it possible to use

redirectTo

with

supabase.auth.update

? By default, it redirects to main page

Can’t really do dynamic redirects yet. I’ve tested so many things. You could use some sort of cookie. But it’s not cross device

Thank you. I hope it changes soon

Auth update

Hello, Where can I find more about Stripe Subscriptions ? Any docs ? I've seen there is a stripe subscription query which I'm interested in creating a product with it. For who is interested(https://supabase.com/docs/guides/examples)

Hello everyone, I'm getting this error while following the nextjs example