Deadlocks and transactions

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Deadlocks and transactions
Date: 2018-03-19 21:46:20
Message-ID: CAAY=A79qwsaTF9yV7+9-BiBZVmNZTN8s0x+a1OjKbDKX=_HMDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a process that inserts a record in one table and, after that, a
record in another table is updated. Because there are 2 DB operations, I
decided to perform both of them in a transaction.

Can a deadlock take place even if transactions are used?

Best regards,
Jorge Maldonado

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2018-03-19 22:18:37 Re: Deadlocks and transactions
Previous Message Tom Lane 2018-03-15 13:55:18 Re: convert legacy self-managed primary keys to postgresql's identity or serial pk's?