Check out our free eBook: "Best Practices for Optimizing Postgres Query Performance"Download Now

U120: Column does not exist

Category: Application / User Errors
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 →