realtime is not emitting DELETE events (but INSERT or UPDATE is working)

[topTOP-Dev]

Bug report

Describe the bug

I'm using the realtime for crud operation.

useEffect(() => {
    // Define an async function for the subscription
    const subscribeToChannel = async () => {
      const subscription = supabase
        .channel(channelRoom)
        .on(
          "postgres_changes",
          {
            event: "*",
            schema: "public",
            table: tableName,
            filter: `dof=eq.${selectedDate.format("YYYY-MM-DD")}`, // Corrected the date formatting
          },
          (payload: any) => {
            console.log(payload);
            switch (payload.eventType) {
              case "UPDATE":
                setAtcFlights((prev: Flight[]) =>
                  prev.map((flight: Flight) =>
                    flight.id === payload.new.id ? payload.new : flight
                  )
                );
                break;
              case "DELETE":
                // setAtcFlights((prev: Flight[]) => {
                //   const updatedFlights = prev.filter(
                //     (flight: Flight) => flight.id !== payload.old.id
                //   );
                //   return updatedFlights;
                // });
                // Optionally, refetch the data to ensure consistency
                fetchFlightList();
                break;
              case "INSERT":
                if (
                  payload.new.airport === airport.toUpperCase() &&
                  payload.new.dof === formattedDate
                ) {
                  setAtcFlights((prev: Flight[]) => [...prev, payload.new]);
                }
                break;
              default:
                break;
            }
          }
        )
        .subscribe();

      // Cleanup function to remove the subscription
      return () => {
        supabase.removeChannel(subscription);
      };
    };

    // Call the async function
    subscribeToChannel();

    // Dependencies for useEffect
  }, [
    supabase,
    tableName,
    formattedDate,
    airport,
    atcFlights,
    setAtcFlights,
    channelRoom,
  ]);

When I run in local development mode, the delete event type is emitted normally. But when I deploy to the production. Such delete event type is not emitted. But the data is deleted from my database as normal.

Screenshots

This is in development.

This is in production. (There are only INSERT or UPDATE event type. The DELETE is not emitted.)

System information

• OS: [e.g. macOS]
• Browser (if applies) [e.g. Microsoft Edge]
• Version of supabase-js: [e.g. 2.45.4]
• Version of Node.js: [e.g. 22.8.0]

[topTOP-Dev]

Thanks a lot. I found out that the delete event type does not contain my dof's value.