U135: Unterminated quoted string
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 string at or near "some string
STATEMENT: SELECT 'some stringExplanation:
The query can't be parsed by PostgreSQL since it contains a syntax error.
This is due to a quoted string that is missing the closing single quotation mark (i.e. 'some string).
Recommended Action:
Fix the query syntax.
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 →