Show error when subscribing to table that realtime isn't enabled on

[danhodkinson]

Would be great if when trying to subscribe to a table - if that table hasn't had realtime enabled then it provides some form of feedback to the user (developer).
I was recently in full debug mode trying to figure out why i was receiving a payload for one subscription but not the other.

[GaryAustin1]

You can get this error now. It is in the websocket messages...

And you can get them in code with the extra .on at the bottom...

 const mySubscription = supabase1
        .channel('mychannel')
        .on('postgres_changes',
            { event: '*', schema: 'public', table: 'accounts'}, (payload) => {
                console.log('Change received!', payload)
            })
        .subscribe((status)=>{
            console.log('subscribe = status',status);
        })
       .on('system', {}, payload => {
        if (payload.extension === 'postgres_changes') {
            console.log('more info',payload);
        }
    })

[danhodkinson]

Thanks @GaryAustin1 is this documented in the Realtime docs anywhere? I didn't spot the additional .on for system changes anywhere?

[GaryAustin1]

Not that I know of. I got from Supabase realtime github issues. It might also be in realtime-js github.

[w3b6x9]

@danhodkinson we have a PR open that specifies this that you can refer to: #10251.