I also have this message on some of my database. I don't know where it comes from.
Cheers, Rémi-C 2014-09-23 1:43 GMT+02:00 Paul Ramsey <[email protected]>: > If you can share data, I'm happy to try and reproduce it here. > > P > > On Mon, Sep 22, 2014 at 2:01 PM, Jason Mathis > <[email protected]> wrote: > > I am stumped on it. I think i remember seeing something like this before, > > but can’t quite recall. > > > > Queries both return zero. > > > > 'POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 > > March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6" > > LIBJSON="UNKNOWN" RASTER' > > > > i even tried putting a bogus null row in there but I still got the > message. > > > > thanks! > > > > > > On September 22, 2014 at 2:52:00 PM, Paul Ramsey ( > [email protected]) > > wrote: > > > > 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 > > > > > > 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
