U120: Column does not exist
Category: Application / User Errors
SQLSTATE: 42703 (Class 42 — Syntax Error or Access Rule Violation: undefined_column)
Urgency: low
SQLSTATE: 42703 (Class 42 — Syntax Error or Access Rule Violation: undefined_column)
Urgency: low
Example Postgres Log Output:
ERROR: column "y" does not exist at character 8
STATEMENT: SELECT y FROM x
ERROR: column "y" of relation "x" does not exist
STATEMENT: ALTER TABLE x DROP COLUMN y;
Explanation:
The query is referencing a column that does not exist. You may have forgotten to add a JOIN for the table/view that contains the column, or mistyped the column name.
Recommended Action:
Fix your query to correctly reference the column. This error would typically happen during development.
Learn More:
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →