<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">You would need to run the analyze manually and look at the results. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><i>vacuumdb -v -a -Z -U postgres -h localhost</i></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">For example the above will run analyze only on all databases and output verbose. You will be able to pin down the table(s) from there. I am going to try and get some sample data to paul to see if he can reproduce it. </div> <div id="bloop_sign_1411486248508992000" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><br></div><div style="font-family:helvetica,arial;font-size:13px">-jason </div></div> <br><p style="color:#000;">On September 23, 2014 at 4:03:18 AM, Rémi Cura (<a href="mailto:remi.cura@gmail.com">remi.cura@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<div dir="ltr">
<div>I also have this message on some of my database.<br></div>
I don't know where it comes from.<br>
<br>
Cheers,<br>
Rémi-C<br></div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2014-09-23 1:43 GMT+02:00 Paul Ramsey
<span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">If
you can share data, I'm happy to try and reproduce it here.<br>
<br>
P<br>
<br>
On Mon, Sep 22, 2014 at 2:01 PM, Jason Mathis<br>
<div class="HOEnZb">
<div class="h5"><<a href="mailto:jmathis@redzonesoftware.com">jmathis@redzonesoftware.com</a>>
wrote:<br>
> I am stumped on it. I think i remember seeing something like
this before,<br>
> but can’t quite recall.<br>
><br>
> Queries both return zero.<br>
><br>
> 'POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921"
PROJ="Rel. 4.8.0, 6<br>
> March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
LIBXML="2.7.6"<br>
> LIBJSON="UNKNOWN" RASTER'<br>
><br>
> i even tried putting a bogus null row in there but I still got
the message.<br>
><br>
> thanks!<br>
><br>
><br>
> On September 22, 2014 at 2:52:00 PM, Paul Ramsey (<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>)<br>
> wrote:<br>
><br>
> It means it sampled 30000 rows and didn't find any geometries
that<br>
> were non-null or non-empty. I suppose it could mean a bug,
though that<br>
> code's been around for a while.<br>
><br>
> select count(*) from yourtable where geom is null;<br>
> select count(*) from yourtable where st_isempty(geom);<br>
> select postgis_full_version();<br>
><br>
> P.<br>
><br>
> On Mon, Sep 22, 2014 at 12:11 PM, Jason Mathis<br>
> <<a href="mailto:jmathis@redzonesoftware.com">jmathis@redzonesoftware.com</a>>
wrote:<br>
>> Does anyone know what this “notice” means? I loaded some
new data into a<br>
>> table from a shape file.Visually it looks good and loaded
without error. I<br>
>> have a nightly analyze job that runs and since loading the
data it spits<br>
>> out<br>
>> this “notice” I don’t know what it means. If I drop the
geom column I do<br>
>> not<br>
>> get this message. I have tried drop/create the index, and
reloading the<br>
>> data without success.<br>
>><br>
>> Thanks!<br>
>><br>
>><br>
>><br>
>> $ /usr/bin/vacuumdb -v -Z -d redzone -t 'demo.homes'<br>
>> INFO: analyzing "demo.homes"<br>
>> INFO: "homes": scanned 2237 of 2237 pages, containing
101937 live rows and<br>
>> 0 dead rows; 30000 rows in sample, 101937 estimated total
rows<br>
>> NOTICE: no non-null/empty features, unable to compute
statistics<br>
>> NOTICE: no non-null/empty features, unable to compute
statistics<br>
>><br>
>> CREATE TABLE demo.homes<br>
>> (<br>
>> gid integer NOT NULL DEFAULT
nextval('demo.homes_gid_seq'::regclass),<br>
>> geolat numeric,<br>
>> geolong numeric,<br>
>> geolevel text,<br>
>> geonumber integer,<br>
>> geostreet text,<br>
>> geocity text,<br>
>> geocounty text,<br>
>> geostate text,<br>
>> zip text,<br>
>> firstname text,<br>
>> lastname text,<br>
>> tiv integer,<br>
>> geom geometry(PointZM,4326),<br>
>> CONSTRAINT homes_pkey PRIMARY KEY (gid)<br>
>> )<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> This transmission contains confidential and privileged
information<br>
>> intended<br>
>> solely for the party identified above. If you receive this
message in<br>
>> error,<br>
>> you must not use it or convey it to others. Please destroy
it immediately<br>
>> and contact the sender at (303) 386-3955 or by return
e-mail to the<br>
>> sender.<br>
>><br>
>><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
><br>
><br>
> This transmission contains confidential and privileged
information intended<br>
> solely for the party identified above. If you receive this
message in error,<br>
> you must not use it or convey it to others. Please destroy it
immediately<br>
> and contact the sender at (303) 386-3955 or by return e-mail
to the sender.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></div>
</div>
</blockquote>
</div>
<br></div>
</div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">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.</font></p>