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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend