Re: select inside transactions - Mailing list pgadmin-hackers

From Andreas Pflug
Subject Re: select inside transactions
Date
Msg-id 43FDE54C.6070304@pse-consulting.de
Whole thread Raw
In response to Re: select inside transactions  ("Magnus Hagander" <mha@sollentuna.net>)
List pgadmin-hackers
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

pgadmin-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pgAdmin server properties dialog
Next
From: "Edward Di Geronimo Jr."
Date:
Subject: Re: Query tool results in grid