Re: Asynchronous query execution

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Asynchronous query execution
Дата
Msg-id 4CFF8AD0.5080602@hogranch.com
обсуждение исходный текст
Ответ на Asynchronous query execution  (c k <shreeseva.learning@gmail.com>)
Ответы Re: Asynchronous query execution  (Merlin Moncure <mmoncure@gmail.com>)
Re: Asynchronous query execution  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
On 12/08/10 5:35 AM, c k wrote:
> Hello,
> I would like to know how can we execute the queries asynchronously?
> If we use and execute plpgsql functions they just completes the
> execution or throws an error on error. In between next sql statement
> waits for the previous one to complete the execution. But in few
> situations it is required not to wait for getting the completion of
> previous sql statement. How can this e achieved?
>

one postgresql connection can only run one query at a time.

run your asynchronous queries from a thread with its own connection



В списке pgsql-general по дате отправления:

Предыдущее
От: Andre Lopes
Дата:
Сообщение: Re: How to obtain the maximum value of a date, between 3 tables...
Следующее
От: Rob Gansevles
Дата:
Сообщение: Maximum size for char or varchar with limit