Re: Testing concurrent psql

On Wed, May 16, 2007 at 09:43:36AM -0400, Gregory Stark wrote:
>
> I'm looking for corner cases where the concurrent psql patch doesn't
> handle things properly. I'm wondering about multiple result sets but
> I can't think of any cases where I can test them.
>
> If you submit multiple commands at the psql prompt then psql seems
> to stop at the first semicolon and send the query separately. The
> only way to send multiple queries together seems to be with -c and I
> don't think we have any intention to support asynchronous queries
> via that route. Regular queries still work fine via this route.
>
> I seem to recall there was a way to construct scenarios that
> returned multiple result sets via rules but I don't know how to
> arrange that. Anyone remember?

I don't know about rules, but you can have a SRF return SETOF
REFCURSOR.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate