Postgres Pro
Downloads
Home   >   mailing lists

Deadlocks and transactions - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Deadlocks and transactions
Date
Msg-id CAAY=A79qwsaTF9yV7+9-BiBZVmNZTN8s0x+a1OjKbDKX=_HMDw@mail.gmail.com
Whole thread Raw
Responses Re: Deadlocks and transactions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: convert legacy self-managed primary keys to postgresql's identity or serial pk's?
Next
From: "David G. Johnston"
Date:
Subject: Re: Deadlocks and transactions