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
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
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
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