🤔

That note is confusing though cause

OnConflict is supposed to be an alternative to primary keys

I have a unique constraint on the

legacyId

- I'm just going to test it. On the otherhand, I could search the entry first and then update, but if it works in one go...

@User - it looks like, it works perfectly 👌

Nice. I was confused about it a while ago and had to just go for it and test. Just couldn’t recall the outcome 😅

Currently unable to add HTTP params within Function Hooks

Only able to add it is if I add a second one, and then remove the first

But then I'm not able to save the function hook anymore

I'm trying to figure out how to pull the schema for the prod db into my local db. Surely, this must exist somewhere but having troubles figuring out how to do this with the cli.

Ended up just doing this with datagrip

I'm lost with how Auth dev is supposed to work locally. Is there way to run Supabase's auth locally (can't find this anywhere). Not sure how any local dev would work without this unless you don't need auth for some reason. Looks like the Authentication tab of running Studio locally only has the Policies tab. Is this an error?

Ah, I didn't see this little dropdown.

Hi, anyone got realtime working with

delete

, yet? I am on a new project (hosted) and already tried enabling the replication in combination with altering the table for full replication, but without any luck 😫 However

insert

,

update

notifications just work fine. I would highly appreciate your help 🙏

Without RLS it works for me just now. If you have RLS on make sure your delete policy would allow user to see the row being deleted. Also Supabase just made some changes, but I've not seen anything specific to deletes.

I don't have RLS enabled for any tables nor did I create any policies, yet. I minted my own jwt `acces_token`s, but I don't see why this wouldn't work just for

delete

events 😅 the phoenix subscription answer looks fine imo

I'm on hosted, with PG 13 and installed 1.28.5 JS. You can see on github several new RLS issues this week, but don't recall delete issue and it is working for me with .from('tablename').on('*',payload=>{}).subscribe()

Oh, I am currently on PG14.1 with the latest client version. Is it possible to manually select the PG version? Thanks, I'm going to check out some of these issues

Is it possible to make multi-column text search queries using the supabase js client?

After doing database.new then sign-in with Github I got an error. It might just be on sign-up/sign-in because when I did database.new in a new tab everything was good and I landed on 'Create a new project'.

Hello, good evening. There's any way of setting up CORS on Supabase to allow only one origin?

How would I go about connecting an existing PostgreSQL database that's on the same machine running supabase on docker?

I looked at the docs but it doesn't explain it very well, when I tried doing it myself I just got authentication errors and connection refused

Hi! I'm using

@supbase/supabase-js

and trying to use the

redirectTo

on

signUp

and it's not working. I'm not sure I understand why:

const {
          error: e,
          user,
          session,
        } = await supabase.auth.signUp(
          { email, password },
          { redirectTo: 'http://localhost:3000/access' }
        );

I have this URL added in my Auth settings as well.

How can I solve this problem

Im pretty sure that user_id is related to auth.users.id

Hello ! Is there any tutorial on how to setup graphql extension with supabase besides the docs?

Schema Cache Reload

maybe https?

good morning. is it possible to limit the origin that can access the API to one URL?