working as expected when executing directly against PostgreSQL servers through the same PostgreSQL ODBC driver

Remove need for quotes around cursor name declarations/fetches -------------------------------------------------------------- Key: TEIID-4238 URL: https://issues.jboss.org/browse/TEIID-4238 Project: Teiid Issue Type: Enhancement Components: ODBC Reporter: Marc Shirley Assignee: Steven Hawkins Fix For: 9.1 Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1. Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...