U110: Syntax error
SQLSTATE: 42601 (Class 42 — Syntax Error or Access Rule Violation: syntax_error)
Example Postgres Log Output:
ERROR: syntax error at or near "WHERE" at character 26" STATEMENT: SELECT * FROM abc LIMIT 2 WHERE id=1
ERROR: syntax error at end of input STATEMENT: SELECT * FROM (SELECT 1
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.
Fix the application code if this occurred outside of an interactive session.
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →