SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then
[SOLVED]

stream not found [SQL0005]

Edit this page
code SQL0005 · recovery permanent — an unchanged retry cannot succeed; retry machinery stops immediately
the log line · Report this thread
SQL0005 Permanent error

As it arrives in your log or error chain — example values stand where yours will:

stream not found: schema "sqlstreams", stream "orders.created", stream_id 1 -- register it with Client.Stream(name).Register first [SQL0005]
ACCEPTED ANSWER Posted: 2026-09-09
brandon Site Admin brandon profile Posts: 677

register it with Client.Stream(name).Register first

brandon Site Admin brandon profile Posts: 677

Helpful info.

  1. the stream row under this name

    SELECT id, name, created_at FROM {schema}.stream_config WHERE name = '{stream}';
  2. the stream row behind an id, if that is what the line carried

    SELECT id, name, created_at FROM {schema}.stream_config WHERE id = {stream_id};
  3. every registered stream, if the name itself is wrong

    SELECT name FROM {schema}.stream_config ORDER BY name;
Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.