Thread: select inside transactions

select inside transactions

From
Andreas Pflug
Date:
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.

Regards,
Andreas

Re: select inside transactions

From
"Magnus Hagander"
Date:
> 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?

//Magnus

Re: select inside transactions

From
Andreas Pflug
Date:
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.

Regards,
Andreas

Re: select inside transactions

From
"Magnus Hagander"
Date:
> >>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 :-(

//Magnus

Re: select inside transactions

From
Andreas Pflug
Date:
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