Q003warning

Unknown table

A table, CTE or table-valued function is not in the catalogue.

db/queries/example.sql:2:1: warning[Q003]: unknown table or view "author" in schema "public"

   |
 2 | SELECT id, name FROM author WHERE id = $1;
   | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

The catalogue is built by replaying your migrations. A table that no migration creates, or that a later migration drops, is unknown to the analyser.

Add the migration that creates the table, or fix the name.

$ sgl explain Q003

Look for UnknownTable in Seagull's source to see where it is reported.