Database row level locking in JDBI and postgres

Question

I am using jdbi with postgres. And as i am running application in multiple instances locking is not an option on application code level. So i am using row level locking on database. So i am using select for update. But ideally i don't need any update to the row but i am going a head due to for update. So everytime to release a lock i fire an update query to update last updated time field, Can i just lock it and once the transaction is done release the lock without any update. DO we have such an option?

user330315 · Accepted Answer · 2020-10-20 06:25:19Z

1

When you commit or rollback your transaction the lock is automatically released, regardless whether you actually updated the row or not.

There is absolutely no need to UPDATE the row in order for the lock to be released.

answered Oct 20, 2020 at 6:25

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database row level locking in JDBI and postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related