It means it sampled 30000 rows and didn't find any geometries that were non-null or non-empty. I suppose it could mean a bug, though that code's been around for a while.
select count(*) from yourtable where geom is null; select count(*) from yourtable where st_isempty(geom); select postgis_full_version(); P. On Mon, Sep 22, 2014 at 12:11 PM, Jason Mathis <[email protected]> wrote: > Does anyone know what this “notice” means? I loaded some new data into a > table from a shape file.Visually it looks good and loaded without error. I > have a nightly analyze job that runs and since loading the data it spits out > this “notice” I don’t know what it means. If I drop the geom column I do not > get this message. I have tried drop/create the index, and reloading the > data without success. > > Thanks! > > > > $ /usr/bin/vacuumdb -v -Z -d redzone -t 'demo.homes' > INFO: analyzing "demo.homes" > INFO: "homes": scanned 2237 of 2237 pages, containing 101937 live rows and > 0 dead rows; 30000 rows in sample, 101937 estimated total rows > NOTICE: no non-null/empty features, unable to compute statistics > NOTICE: no non-null/empty features, unable to compute statistics > > CREATE TABLE demo.homes > ( > gid integer NOT NULL DEFAULT nextval('demo.homes_gid_seq'::regclass), > geolat numeric, > geolong numeric, > geolevel text, > geonumber integer, > geostreet text, > geocity text, > geocounty text, > geostate text, > zip text, > firstname text, > lastname text, > tiv integer, > geom geometry(PointZM,4326), > CONSTRAINT homes_pkey PRIMARY KEY (gid) > ) > > > > > > > This transmission contains confidential and privileged information intended > solely for the party identified above. If you receive this message in error, > you must not use it or convey it to others. Please destroy it immediately > and contact the sender at (303) 386-3955 or by return e-mail to the sender. > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
