Re: Query results in grid, new patch

Andreas Pflug wrote:
> Dave Page wrote:
>>> -----Original Message-----
>>> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de] Sent: 06 March
>>> 2006 09:42
>>> To: Florian G. Pflug
>>> Cc: Dave Page; Edward Di Geronimo Jr.; pgadmin-hackers(at)postgresql(dot)org
>>> Subject: Re: [pgadmin-hackers] Query results in grid, new patch
>>>
>>> Florian G. Pflug wrote:
>>>
>>> .) Could the initial size of the columns be choosen so,
>>> that the captions are not cut off? Or, even better,
>>> pgadmin could remember the with of the
>>> columns between selects, at least if the captions stay the same...
>>>
>>> The old control's behaviour was like that.
>>
>> Yes, it was, but it might be a nice fix. It's bugged me for a while.
>
> Hu? I meant the control *does* remember column sizing for repeated
> execution of similar queries since 1.2!!! This is not a "nice fix", it
> is *required*. I don't give a cent for copy/paste from the result (in 10
> years on SQL RDBMS, I might have done that 5 times), I need repeatable
> results from query tuning.
> Trying to autosize the column from content doesn't work satisfying.

I've seem to have never noticed that.. ;-) I guess it's because most times
i switch between two or more different queries, and the code doesn't handle
that. I just experimented a bith with the latest 1.4 snapshot, and found a
bug - it seems like a columns with is only remembered when the column "moves
to the right", not when it "moves to the left".

Another usefull feature (If it isn't already there, just under my nose ;-) )
would be to have tooltips displaying the full name of a column. I often resize
the columns to be just wide enough to show the data, and more often than not,
the caption is far longer than that.

greetings, Florian Pflug