Is it possible to commit a transaction and start a new one without releasing the row locks? - PeakU

0

90

Views

Is it possible to commit a transaction and start a new one without releasing the row locks?

I have a use case where I need to:

Update a row.
Persist the changes to disk, such that a system crash will not reverse it.
Update the same row that has not been modified by another transaction (a race condition).

How would I achieve this? Is it possible to commit a transaction and start a new one without releasing the row locks?

over 4 years ago · Santiago Trujillo

1 answers

Answer question

0

Postgres supports Advisory Locks, that can be hold over Session Lifetime. If all your threads use these locks, you would be safe.

over 4 years ago · Santiago Trujillo Report

Answer question

Find remote jobs