Re: [GENERAL] Postgres concurrency : urgent

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [GENERAL] Postgres concurrency : urgent
Дата
Msg-id 382B6C05.22A36786@krs.ru
обсуждение исходный текст
Ответ на Postgres concurrency : urgent  ("V Krishnaraj" <kimi@intercept.co.in>)
Список 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 по дате отправления:

Предыдущее
От: Myles Chippendale
Дата:
Сообщение: Re: [GENERAL] Large database problems
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [GENERAL] Postgres concurrency : urgent