I'm facing an issue where INSERTs and UPDATEs are not replicated (realtime) but DELETEs are?

Hello @tavin! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Deletes ignore RLS. So likely you are not meeting RLS for select. Can you show your subscription call if you think you have RLS set correctly.

tavin (2022-04-09)

Is that what you meant?

I'm thinking something else has to be done if you use just realtime-js versus supabase-js... I'll have to see if I can find the discussion. Possibly doc was not updated to current level...

Alright, I'll see if I can find something as well in the mean time.

So looks like the issue with docs, was the param apikey used to be missing in one of them, and is in both now (realtime.js and realtime server). Is your REALTIME_KEY your anon key?

Yes

I don't use realtime-js (use supabase-js for realtime) But at a reasonable glance your code looks OK. Double check RLS, as that is what seeing delete only points to, and that you have insert/update toggled on in replication. Is this hosted?

Doubled checked everything just now

I'd send in a support request, I've seen several cases of realtime issues needing support to "touch" the server...

Alright then

YOu could slam in supabase-js and use the .subscribe method as a sanity check.

I've tried it as well haha

The thing I hate about hosted services is you can't just whack the side of the box to get it going....

What do you mean about hosted? Like hosted in Supabase's services?

It was a joke about hitting electronics and they start working. Sorry. You are using Supabase cloud, it seems you are since you say create another project?

Yeah, on free plan

Make sure to use the help tab in the project as it sends all the info they need to see your instance.

Sure, will do

@tavin this might be it... var channel = socket.channel('realtime:public:rls_table', { user_token: JWT })

Hey @garyaustin. I've contacted the support team and we were able to identify the issue. Quoted from the response:

There is an existing issue with Realtime where types that are wrapped by double quotes will break replication. Prisma is known to wrap types (enums) in double quotes.

. The temporary solution for it, is to recreate your project and avoid using enums. It's worth mentioning that it's not reversible, so you must recreate your project for it to work.

Hey thanks for letting me know.. I'll add that to my list of questions to ask next time...