SupabaseS
Supabase8mo ago
Kapxy

Realtime logs has a lot of errors like this

PoolingReplicationError: %Postgrex.Error{
  message: nil,
  postgres: %{
    code: :syntax_error,
    line: "1188",
    message: "syntax error at or near \"-\"",
    file: "scan.l",
    unknown: "ERROR",
    where: "invalid type name \"-1597984915\"\nPL/pgSQL function realtime.apply_rls(jsonb,integer) line 51 at assignment\nSQL function \"list_changes\" statement 1",
    severity: "ERROR",
    pg_code: "42601",
    internal_query: "columns =\n    array_agg(\n        (\n            x->>'name',\n            x->>'type',\n            x->>'typeoid',\n            realtime.cast(\n                (x->'value') #>> '{}',\n                coalesce(\n                    (x->>'typeoid')::regtype, -- null when wal2json version <= 2.4\n                    (x->>'type')::regtype\n                )\n            ),\n            (pks ->> 'name') is not null,\n            true\n        )::realtime.wal_column\n    )\n    from\n        jsonb_array_elements(wal -> 'columns') x\n        left join jsonb_array_elements(wal -> 'pk') pks\n            on (x ->> 'name') = (pks ->> 'name')",
    internal_position: "1",
    routine: "scanner_yyerror"
  },
  connection_id: 221656,
  query: nil
}
`

anyone know whats up?
Was this page helpful?