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

0

92

Visualizações

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 Respostas

Responde à pergunta

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 Relatório

Responde à pergunta

Encontrar trabalhos remotos