| From: | "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> |
|---|---|
| To: | "postgresql" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Q about transactions |
| Date: | 2003-04-13 14:42:59 |
| Message-ID: | 00c401c301ca$fa942420$aa0f5ac2@canaan.co.il |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ?
Thanks in Advance :)
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://sites.canaan.co.il
--------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Singer | 2003-04-13 15:48:07 | Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit |
| Previous Message | Bruno Wolff III | 2003-04-13 14:21:00 | Re: Q about transactions |