Re: [GENERAL] Postgres concurrency : urgent

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: V Krishnaraj <kimi(at)intercept(dot)co(dot)in>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Postgres concurrency : urgent
Date: 1999-11-12 01:23:17
Message-ID: 382B6C05.22A36786@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vadim Mikheev 1999-11-12 01:25:15 Re: [GENERAL] Postgres concurrency : urgent
Previous Message Ed Loehr 1999-11-11 22:17:45 How to enable PL/pgsql for functions/triggers