Re: [GENERAL] Postgres concurrency : urgent

1999-11-11 Thread Vadim Mikheev
V Krishnaraj wrote: > > This application works fine when we are in single user. When we > go into multi-user, the app has concurrency problems. > > The application has a sql query and updates onto the base table in > the sql query. We are using Select FOR UPDATE to open the > cursor and multiple

Re: [GENERAL] Postgres concurrency : urgent

1999-11-11 Thread Vadim Mikheev
Marcin Inkielman wrote: > > I 'm using : > > LOCK <> 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

Re: [GENERAL] Postgres concurrency : urgent

1999-11-11 Thread Marcin Inkielman
On Fri, 12 Nov 1999, V Krishnaraj wrote: > Hi, > > I'm having a postgres database accessed from perl using DBI and > DBD. > > This application works fine when we are in single user. When we > go into multi-user, the app has concurrency problems. > > The application has a sql query and update

[GENERAL] Postgres concurrency : urgent

1999-11-11 Thread V Krishnaraj
Hi, I'm having a postgres database accessed from perl using DBI and DBD. This application works fine when we are in single user. When we go into multi-user, the app has concurrency problems. The application has a sql query and updates onto the base table in the sql query. We are using Select