The API querying a table that was never migrated

Repair the migration path and verify the API query against the new table.

14 min/PostgreSQL / migrations / schema diagnosis

Observe

Investigate

Fix

Verify

Reflect

migrations/004_users.sql/sql

01020304

-- deploy the users table before the API starts
SELECT * FROM users;

-- TODO: create the table

Terminal0 runs

ERROR: relation "users" does not exist
STATEMENT: SELECT * FROM users;

Migration 004 failed. The API cannot boot against an incomplete schema.