U119: Relation does not exist
SQLSTATE: 42P01 (Class 42 — Syntax Error or Access Rule Violation: undefined_table)
Example Postgres Log Output:
ERROR: relation "x" does not exist at character 15 STATEMENT: SELECT * FROM x
The query is referencing a table or view that does not exist in the database.
You may have connected to the wrong database, mistyped a table name or forgot to specify the schema.
Usually no action required as this occurs mostly with typos in interactive sessions.
Sometimes application code generates table names (e.g. with timeseries data split up by date), where you may also see this error occur when there are ordering issues, i.e. a table gets queried before it was created.
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →