Re: [GENERAL] Postgres concurrency : urgent

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