Re: Asynchronous query execution - Mailing list pgsql-general

From John R Pierce
Subject Re: Asynchronous query execution
Date
Msg-id 4CFF8AD0.5080602@hogranch.com
Whole thread Raw
In response to Asynchronous query execution  (c k <shreeseva.learning@gmail.com>)
Responses Re: Asynchronous query execution  (Merlin Moncure <mmoncure@gmail.com>)
Re: Asynchronous query execution  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Andre Lopes
Date:
Subject: Re: How to obtain the maximum value of a date, between 3 tables...
Next
From: Rob Gansevles
Date:
Subject: Maximum size for char or varchar with limit