[postgis-users] identifying blank geometry fields

[Mark Cave-Ayland]

Bob Hume wrote:

> select count(*) from dum where the_geom is null  gives a result of 0
> 
> select count(the_geom) from dum gives a result is 1676, which is the 
> total number of rows in the table
> 
> This is consistent with my previous description.  The apparently blank 
> the_geom fields apparently have some data, but the data doesn't 
> display.  This seems odd, and makes it difficult (impossible for me, so 
> far) to identify the blank fields.

Hi Bob,

Are you using pgAdmin? This is a known issue with the toolkit used in 
pgAdmin in that it can't display rows longer than a certain size (I 
can't remember if it's 32K or 64K at the moment).

If you try the same query from the command line in psql, you should be 
able to see your geometries without any problems.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs