Re: Asynchronous query execution

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