Re: Set statement timeout in the query tool

On Fri, Dec 4, 2009 at 5:33 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:

> I see a use case for having both. If someone uses a lot the statement_timeout
> option, he'll be annoyed to put it in the text box every time he launches the
> query tool.

Just save the value in the toolbar using sysSettings.

>> Why save/reset it? The next query will just change it again anyway,
>> and there's no way round that.
>>
>
> Because every other query launch by the query tool will use it. For example
> the one of the GQB (which, AFAIK, uses the same connection).

Right - but you'd still only need to set it once, when the window is
opened, or if the value is changed. There's no need to keep resetting
it.

> I don't have any issues with adding a UI for other parameters (work_mem comes
> to mind immediately). We can put them all in their own toolbar, so that users
> can hide it, so that it doesn't cluter the window UI.

I do. Extra code maintenance and complexity for little gain.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com