Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Postgres concurrency : urgent - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] Postgres concurrency : urgent
Date
Msg-id 382B6C7B.77C57F5A@krs.ru
Whole thread Raw
In response to Re: [GENERAL] Postgres concurrency : urgent  (Marcin Inkielman <marn@wsisiz.edu.pl>)
Responses Re: Postgres concurrency : urgent  ("V Krishnaraj" <kimi@intercept.co.in>)
Re: [GENERAL] Postgres concurrency : urgent  (Marcin Inkielman <marn@wsisiz.edu.pl>)
List pgsql-general
Tree view 
Marcin Inkielman wrote:
>
> I 'm using :
>
> LOCK <<tablename>> IN ACCESS EXCLUSIVE MODE;
                        ^^^^^^
This blocks concurrent read access - is it what you really want?

> to control concurrent transactions - it works for me
> (postgres 6.5.2)

Vadim

pgsql-general by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [GENERAL] Postgres concurrency : urgent
Next
From: "Dean Jones"
Date:
Subject: Database Creation Help