SELECT FOR UPDATE is not working

Open clemens-smartparking opened this issue 4 years ago • 2 comments

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

May 19 '21 00:05 clemens-smartparking

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

May 19 '21 06:05 oguimbal

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

May 31 '21 01:05 clemens-smartparking