transactions - Mailing list pgsql-general

From Surabhi Ahuja
Subject transactions
Date
Msg-id CE5C48E227F8ED4990FAC4332100ADC621B543@EVS.iiitb.ac.in
Whole thread Raw
Responses Re: transactions
List pgsql-general

Hello everyone.
I have the following question:

say i have two transactions going on simultaneoulsy.
in one transaction i do an insertion
and the other transaction i do a delete.
what will happen if in both the transactions, the insert(in one) and delete(in the other) are issued at exactly the same time? will bothe get blocked and enter into a deadlock, if yes then do both the transactions get aborted after some time of waiting.

Regards
Surabhi Ahuja

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""
Next
From: Michael Fuhr
Date:
Subject: Re: Download mirrors not found?