Re: select inside transactions

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

Magnus Hagander wrote:
> > > > I had to revert the patch on pgSetBase.cpp (Rev4986) 
> >
> > because to handle 
> >
> > > > the very special case of selects inside transactions when 
> >
> > executed in 
> >
> > > > a single step (I'd recommend to execute them step by step) the 
> > > > standard case of a query returning no data (e.g. drop table foo) 
> > > > didn't return messages any more.
> > >
> > >
> > > Yikes. I guess my disclaimer was well placed ;-)
> > >
> > > Did you just revert it, or did you figure out a proper way 
> >
> > of doing it?
> >
> > Just reverted. Currently I don't see a proper way to implement it, 
> > unless multiple output panes (as in isqlw) are implemented.
>
>
> Bummer. I had that feeling - it seemed to easy :-(

You could try to store the last result (for later returning), and drop 
it if a newer is detected. Please take care that return code of *all* 
commands are reported.

Regards,
Andreas