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

From Vadim Mikheev
Subject Re: [GENERAL] Postgres concurrency : urgent
Date
Msg-id 382B6C05.22A36786@krs.ru
Whole thread Raw
In response to Postgres concurrency : urgent  ("V Krishnaraj" <kimi@intercept.co.in>)
List pgsql-general
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 update statements to update values on different

FOR UPDATE cursors are not implemented, yet. How could you use them?

> base tables. When multiple users are running the program, after a
> few iterations postmaster startsputting out messages that there are
> concurrency problems due to which the execute before the fetch
> fails.

What messages?

Vadim

pgsql-general by date:

Previous
From: Myles Chippendale
Date:
Subject: Re: [GENERAL] Large database problems
Next
From: Vadim Mikheev
Date:
Subject: Re: [GENERAL] Postgres concurrency : urgent