Select for update doesn't work properly in embedded PostgreSQL

yandex-qatools / postgresql-embedded

Embedded PostgreSQL Server

Other

493 stars 90 forks source link

Select for update doesn't work properly in embedded PostgreSQL #116

Closed Restless-Anchoret closed 6 years ago

Restless-Anchoret commented 6 years ago

Hi.

I found out, that performing "select for update" operation in two parallel transactions does not lock any of these transactions. So following update operations are performing simultaneously and it causes unexpected errors.

The same code works properly in real PostgreSQL database, so I suppose something works incorrectly in embedded PostgreSQL.

Can you help me, please?

Restless-Anchoret commented 6 years ago

Sorry, I found the cause of this problem, and that was not Embedded PostgreSQL. Closing this issue.