U110: Syntax error
Category: Application / User Errors
SQLSTATE: 42601 (Class 42 — Syntax Error or Access Rule Violation: syntax_error)
Urgency: low
SQLSTATE: 42601 (Class 42 — Syntax Error or Access Rule Violation: syntax_error)
Urgency: low
Example Postgres Log Output:
ERROR: syntax error at or near "WHERE" at character 26"
STATEMENT: SELECT * FROM abc LIMIT 2 WHERE id=1ERROR: syntax error at end of input
STATEMENT: SELECT * FROM (SELECT 1Explanation:
This log event occurs when a query can't be parsed by the Postgres SQL parser. Typically you would see this if someone mistyped a query in an interactive session.
It may also indicate a bug in application logic, especially when using handwritten SQL.
Recommended Action:
Fix the application code if this occurred outside of an interactive session.
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 →