"Surabhi Ahuja " <surabhi.ahuja@xxxxxxxxxxx> writes: > 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. The transactions will be executed completely independently, unless you do explicit locking (via SELECT FOR UPDATE or LOCK TABLE). -Doug ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
