U120: Column does not exist
SQLSTATE: 42703 (Class 42 — Syntax Error or Access Rule Violation: undefined_column)
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;
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.
Fix your query to correctly reference the column. This error would typically happen during development.
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →