Re: Q about transactions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ben-Nes Michael <miki(at)canaan(dot)co(dot)il>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Q about transactions
Date: 2003-04-13 14:21:00
Message-ID: 20030413142100.GA5128@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Apr 13, 2003 at 16:42:59 +0200,
Ben-Nes Michael <miki(at)canaan(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2003-04-13 14:42:59 Q about transactions
Previous Message Alam Surya 2003-04-13 10:51:49 Re: How to drop column ?