order of database modifications in a single transaction

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: order of database modifications in a single transaction
Date: 2003-02-24 06:44:49
Message-ID: 3E59BF61.F887D1AB@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-02-24 08:33:15 Re: A few questions to real pgsql gurus
Previous Message mike McGire 2003-02-24 05:53:35 A few questions to real pgsql gurus