Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Michael Shapiro
As long as the copy/paste works, you could add a hint (or have a displyed value) that says that On Wed, Jul 28, 2010 at 8:49 AM, Jeff Adams wrote: > Again, I don't know wxWidgets, but usually a custom renderer wouldn't > affect copy/paste because it is merely affecting what's drawn to the screen

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Jeff Adams
The wxWidgets bug I filed got changed to "low priority" with the following comment: "I think for now the best (and simplest) workaround is to not use such long strings in wxGrid" So unfortunately I wouldn't expect a fix in wxWidgets any time soon. On Wed, Jul 28, 2010 at 9:49 AM, Jeff Adams wro

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Jeff Adams
Again, I don't know wxWidgets, but usually a custom renderer wouldn't affect copy/paste because it is merely affecting what's drawn to the screen, not the value actually "in" the cell. And right now there isn't anything rendered at all. On Wed, Jul 28, 2010 at 9:28 AM, Michael Shapiro wrote: > I

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Michael Shapiro
I think changing the background but leaving the current value "as is" is better than changing the value. That way you indicate that the value is there (and can be retrieved with copy/paste) but that you can't show it (and perhaps add a pop-up hint when the mouse is moved over the cell) On Wed, Jul

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Guillaume Lelarge
Le 28/07/2010 13:59, Jeff Adams a écrit : > The class that I experience the problem with is the ctlSQLGrid, which > extends wxGrid. I don't know wxWidgets at all, but in the grid sample class > they have an example of setting a cell renderer, perhaps you could add a > cell renderer that changes th

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-28 Thread Jeff Adams
The class that I experience the problem with is the ctlSQLGrid, which extends wxGrid. I don't know wxWidgets at all, but in the grid sample class they have an example of setting a cell renderer, perhaps you could add a cell renderer that changes the background color [or even renders a string that

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Guillaume Lelarge
Le 27/07/2010 22:26, Jeff Adams a écrit : > The bug is definitely a wxWidgets bug, and exists both in 2.8.11 and 2.9.1. > I was able to reproduce it in their "grid" sample. > > I submitted a bug to the wxWidgets project: > > http://trac.wxwidgets.org/ticket/12276 > > Do you think pgAdmin should

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Jeff Adams
The bug is definitely a wxWidgets bug, and exists both in 2.8.11 and 2.9.1. I was able to reproduce it in their "grid" sample. I submitted a bug to the wxWidgets project: http://trac.wxwidgets.org/ticket/12276 Do you think pgAdmin should implement some sort of temporary fix in the meanwhile? Th

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Guillaume Lelarge
Le 27/07/2010 21:01, Jeff Adams a écrit : > I'm attempting to get a wxGrid sample working so I can test it. > You need to compile wxWidgets code for that. Make sure you get 2.8 branch. We don't support 2.9 right now. > One option simpler than changing grid components would be changing something

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Jeff Adams
I'm attempting to get a wxGrid sample working so I can test it. One option simpler than changing grid components would be changing something about the cell (for example, a really ugly option would be changing the background color) whenever you set data in excess of 65535 characters on windows...

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Guillaume Lelarge
Le 27/07/2010 19:31, Jeff Adams a écrit : > Correct, it's the "looking empty" that I'm suggesting is a bug. > Works for me on Linux. It could be with the wxGrid on specific platforms. Switching to another grid component would be quite a work. -- Guillaume http://www.postgresql.fr http://dal

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Jeff Adams
Correct, it's the "looking empty" that I'm suggesting is a bug. On Tue, Jul 27, 2010 at 1:27 PM, Michael Shapiro wrote: > It looks blank, but its contents are actually there. ctrl-a, ctrl-c in the > column selects what you''d expect to see. > The behavior happens a 65536 in the lpad > > select lp

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Michael Shapiro
It looks blank, but its contents are actually there. ctrl-a, ctrl-c in the column selects what you''d expect to see. The behavior happens a 65536 in the lpad select lpad('test', 65535, 't')-- looks OK select lpad('test', 65536, 't')-- looks empty (but really isn't) On Tue, Jul 27, 2010

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Peter Geoghegan
Here's Jeff's test case. I am not immediately able to check it: On 27 July 2010 17:54, Jeff Adams wrote: > Piece o' cake: > > select lpad('test', 75, 't') as test75, lpad('test', 750, 't') as test750, > lpad('test', 7500, 't') as test7500, lpad('test', 75000, 't') as test75000, > lpad('test', 100

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-27 Thread Peter Geoghegan
On 26 July 2010 17:50, Jeff Adams wrote: > Sorry one mistake, I copied the value by selecting the cell and using > ctrl-c, there is no right-click copy. Hi Jeff, Are you sure that the cell doesn't start with an EOL that prevent you from seeing the string without resizing it, or without copying i

Re: [pgadmin-support] Bug with exceptionally long values.

2010-07-26 Thread Jeff Adams
Sorry one mistake, I copied the value by selecting the cell and using ctrl-c, there is no right-click copy. On Mon, Jul 26, 2010 at 12:36 PM, Jeff Adams wrote: > pgAdmin v1.10.3 > Windows XP SP3 > PostgreSQL 8.4.4 > > Any time I do a select that produces a really really long value, > instead of s

[pgadmin-support] Bug with exceptionally long values.

2010-07-26 Thread Jeff Adams
pgAdmin v1.10.3 Windows XP SP3 PostgreSQL 8.4.4 Any time I do a select that produces a really really long value, instead of showing the value pgAdmin has a blank cell in the output. The value is actually there if I right click and copy, then paste into a text editor, just not displayed. The value