Hello guys, I encountered a problem that I cannot ...
# helpu
usamichizuru
04/17/2022, 4:36 PMHello guys, I encountered a problem that I cannot understand no matter what. It appeared that my realtime Supbase cannot specifically listen to DELETE however can listen to INSERT AND UPDATE. I even try to use "*" to select or event but when it came down to DELETE, it did not listen.
n
Needle
04/17/2022, 4:36 PMHello @usamichizuru!
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
/titleg
garyaustin
04/17/2022, 4:49 PMObvious, but I'll ask you have delete checked in the replication options.
Can you show your subscription code?
Also try this:
ALTER TABLE your_table REPLICA IDENTITY FULL;
n
Needle
04/17/2022, 4:49 PMusamichizuru (2022-04-17)
u
usamichizuru
04/17/2022, 5:09 PMI mean it works on INSERT but DELETE doesnt. I really have no idea because I even check use "*" to output all payload but when ever the DELETE event occurred, it did not call
g
garyaustin
04/17/2022, 5:10 PMTry the alter table I showed above with your table name, in the SQL editor. You are using a filter and you may need the full replica identity for that to work on delete.
u
usamichizuru
04/17/2022, 5:12 PMHow to do that? Use SQL?
g
garyaustin
04/17/2022, 5:13 PMYes in the sql editor window of dashboard
u
usamichizuru
04/17/2022, 5:26 PMOkay I dont know but I messed up.
usamichizuru
04/17/2022, 5:27 PMafter doing this and my entire database got error with a message JWT expired
usamichizuru
04/17/2022, 5:39 PMAnd I find out that it only happened on development evironment, my already published website work normally.
g
garyaustin
04/17/2022, 5:40 PMI just had all my hosted dashboards need to be reloaded... that sql would not cause it.