order of database modifications in a single transaction
От | Dennis Gearon |
---|---|
Тема | order of database modifications in a single transaction |
Дата | |
Msg-id | 3E59BF61.F887D1AB@cvc.net обсуждение исходный текст |
Ответы |
Re: order of database modifications in a single transaction
|
Список | pgsql-general |
Can it be assumed that the database will try to commit all the updates, deletes, and inserts in the order they are submitted during a single transaction for the sake of planning trigger firing order? In the following scenarios? A/ From within a procedure run from the command shell or a external script. B/ From withing a procedure from the command line. C/ with Autocommit off and within Begin and end blocks of a transaction. Is this a general assumption possible with all transaction supporting databases, that at the moment of commitment a single transaction, the database modifications in that transactions will be popped from a queue FIFO and committed individually in order? Also, when one transaction is committing does it own that bottleneck blocking other transactions from committing until the whole queue of DB modifications in the current committing transaction are done? I.E. it gets a semaphore for the commitment functionality? ( I guess I could have worded that to say, is the commitment phase of a transaction atomic relative to other pending transactions? ) -- Carpe Dancem ;-) ----------------------------------------------------------------- Remember your friends while they are alive ----------------------------------------------------------------- Sincerely, Dennis Gearon
В списке pgsql-general по дате отправления: