[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] identifying blank geometry fields
From:       Bob Hume <bobh () lbblawyers ! com>
Date:       2009-11-25 6:12:03
Message-ID: 4B0CCAB3.2010908 () lbblawyers ! com
[Download RAW message or body]

Well, apparently it is a problem of pgAdmin not displaying the the_geom 
data, not that it doesn't exist.  Query  --   select name, the_geom, 
St_Length(the_geom) from dum;    --   shows a length for each row that 
appears to have a blank the_geom field.  I guess that explains why 
trying to find the blank the_geom fields with null didn't work; they 
aren't null.  I tried running the query in psql, but have a windows 
console conflict and don't want to take the time to figure out how to 
fix it so I can run the query directly in psql in Windows.  I'm a rookie 
and pgAdmin is enough for me.

Thanks all for the prompt and good troubleshooting suggestions.

-- Bob Hume

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]