Re: Q about transactions - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Q about transactions
Date
Msg-id 20030413142100.GA5128@wolff.to
Whole thread Raw
In response to Q about transactions  ("Ben-Nes Michael" <miki@canaan.co.il>)
List pgsql-general
On Sun, Apr 13, 2003 at 16:42:59 +0200,
  Ben-Nes Michael <miki@canaan.co.il> wrote:
> Hi All
>
> What happens when two people try to update the same table simultaneously ?
>
> The second one wait until the first one finish ?
>
> Also what happens when the transaction is more complex then one update ?
> I mean first I read some tables and then start to update / delete / insert
> other tables ( using function for example )
>
> will the second action will wait until the function transaction will end ?

Read: http://developer.postgresql.org/docs/postgres/mvcc.html


pgsql-general by date:

Previous
From: "Ben-Nes Michael"
Date:
Subject: Q about transactions
Next
From: "Ed L."
Date:
Subject: Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit