Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

error with transaction: SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;; #404

Open
GGAlanSmithee opened this issue May 17, 2024 · 0 comments

Comments

@GGAlanSmithee
Copy link

Describe the bug

When attempting to run a query in a transaction,

QueryError: 馃挃 Your query failed to parse.
This is most likely due to a SQL syntax error. However, you might also have hit a bug, or an unimplemented feature of pg-mem.
If this is the case, please file an issue at https://github.com/oguimbal/pg-mem along with a query that reproduces this syntax error.

馃憠 Failed query:

    SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;;

馃拃 Syntax error at line 1 col 29:

1  SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;;
                               ^
Unexpected kw_as token: "as". Instead, I was expecting to see one of the following:

    - A "op_eq" token
    - A "kw_to" token

To Reproduce

SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;;

pg-mem version

"version": "2.8.1"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant