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’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SELECT FOR UPDATE is not working #117

Open
ghost opened this issue May 19, 2021 · 2 comments
Open

SELECT FOR UPDATE is not working #117

ghost opened this issue May 19, 2021 · 2 comments

Comments

@ghost
Copy link

ghost commented May 19, 2021

Is there any plan to support different isolation levels? If not this is probably easy to add :)

@oguimbal
Copy link
Owner

Given that pg-mem does not support concurrent transactions, supporting select for update has no meaning. (if two transactions run il parallel, the last one to commit will fail).

pg-mem does not intend to reimplement a full-blown pg instance, only what's sufficient to write tests.

So it could make sense to implement select for update, but only to ignore it and implement it as a regular select

@ghost
Copy link
Author

ghost commented May 31, 2021

With the changes from pgsql-ast-parser this issue should be resolved. Any plans to publish a new npm version soon?

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