Le 11 avr. 2015 01:44, "Tim Uckun" <timuc...@gmail.com> a écrit : > > I have been it in two steps but sometimes I jump on to another task and forget that I have an open transaction and shut down the app. >
This shouldn't be an issue because the rollback is automatic this way. > Anyway I would like to request a feature to let me see intermediate results because for me anyway it's not unusual to chain multiple statements together. > That feature is frequently asked, quite possible, but hard to do. Mostly on the UI part. You need to find someone quite motivated and who has time on his hands. > Thanks. > > On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge <guilla...@lelarge.info> wrote: >> >> Hi, >> >> 2015-04-10 1:13 GMT+02:00 Tim Uckun <timuc...@gmail.com>: >>> >>> I want to to do the following. >>> >>> begin; >>> explain analyze blah >>> rollback; >>> >>> If I do this I don't get the results of the analyze. >>> >>> I have been resorting to commenting out the rollback and running it separately but it's a bit of a pain. >>> >>> Is there an easier way to do this? >>> >> >> Nope. The query tool gets the result of the last query only. So you need to do it in two steps. >> >> >> -- >> Guillaume. >> http://blog.guillaume.lelarge.info >> http://www.dalibo.com > >
