Re: Concurrent psql API

Tom Lane wrote:

> \join connID
> 
> 	Switch to connection connID.  If it is busy, wait for
> 	command completion and print the result before offering
> 	a new command prompt.

When switching to a conn we also need a non-destructive way out if it is 
busy.


> \join	(or \join - as per Alvaro)
> 
> 	Wait for any currently busy connection's command to finish,
> 	then \join to it.  Error if there is no busy connection.
> 

So what you suggest is that if you have 10 busy conns running \join will 
send you to the next conn to return a result?

On that - listing the current conns could be useful to have some status 
info with the list to indicate idle or running what command.



-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz