U136: Unterminated quoted identifier
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: unterminated quoted identifier at or near ""1" at character 8
STATEMENT: SELECT "1Explanation:
The parser failed to read the query since it contains a syntax error.
You will see this log event when you forgot to add the closing double quotes for an identifier in the query, e.g. when writing the name of a table in double quotes.
Recommended Action:
Rewrite the query to correctly close the double quotation marks.
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 →