Thread: Version 1.10.5

Le 24/04/2011 19:01, Bob Pawley a écrit :
> [...]
> I am having trouble and it seems to be this version of PGAdmin.
> 
> Some geometry fields are not visible in the table view and return a null value on a simple select query.
> 

Not visible and NULL are not the same thing. Empty strings are of course
not visible. NULL values are usually not visible in the query tool. In
the edit grid, you can ask pgadmin to display a special value. Really
long values (big big string) sometimes aren't display in a good way,
which is obviously not good. This is a big issue with pgadmin, that we
are aware of. We need to work on that for the next release (I mean 1.16,
and not 1.14).

> These fields do contain information. 
> 
> I can copy the supposedly null fields to clipboard and paste the result to word.
> 
> Using version 1.10.0 all of these fields are fully accessible.
> 
> The fields are quite large (3 plus pages in word).
> 
> Is this a known problem or am I not doing something properly??
> 

The issue is in pgAdmin, not you :)

And I don't think 1.10.0 had anything special that could make them
appear. This is just an issue with the way pgAdmin and wxWidgets deal
with really long strings in a grid.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

Hi Guillaume 

I've looked a little more closely.

When I expand the cell that appears empty, it shows a long stretch of blank
space.

As I slide the view to the left the data comes into view. The data is there,
so that part is fine.

When I view the same table on the pgadmin version 1.10.0 which is looking at
both a local and remote DB the expanded cell is never completley empty.

Prehaps there is a method in which I can shorten the white space after the
data(geometry column)?

My real problem is when I am troublshooting a function the output shows
empty no matter how long I make the field.

So I don't know when the function works and when it doesn't.

Do you have a time line when this may be corrected?

Bob

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Version-1-10-5-tp4336654p4341209.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Le 26/04/2011 17:30, Bob Pawley a écrit :
> Hi Guillaume 
> 
> I've looked a little more closely.
> 
> When I expand the cell that appears empty, it shows a long stretch of blank
> space.
> 
> As I slide the view to the left the data comes into view. The data is there,
> so that part is fine.
> 
> When I view the same table on the pgadmin version 1.10.0 which is looking at
> both a local and remote DB the expanded cell is never completley empty.
> 
> Prehaps there is a method in which I can shorten the white space after the
> data(geometry column)?
> 

No, I don't think there is such a method.

> My real problem is when I am troublshooting a function the output shows
> empty no matter how long I make the field.
> 
> So I don't know when the function works and when it doesn't.
> 
> Do you have a time line when this may be corrected?
> 

1.10 won't be fixed, it's "too old". Did you try 1.12.3? and 1.14 beta 1
should be released soon, you should also try it.

I looked at the diff between 1.10.0 and 1.10.5, and there's nothing that
would explained what you see.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

Hi Guillaume

I've installed version 1.10.0, whiich was showing all of the geomnetry rows
on my other machine (XP) onto my main computer (Win 7). No solution.

From all of my attempts at finding the problem it is begining to look as
though Windows 7 may be of concern.

FYI, other freeware and proprietary versions of PGAdmin give me no problems
in viewing all geometries.

Hope this helps.

Bob

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Version-1-10-5-tp4336654p4347012.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.