<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;">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. </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;">Thanks!</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;"><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;"><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;"><div id="bloop_customfont" style="margin: 0px;">$ /usr/bin/vacuumdb -v -Z -d redzone -t 'demo.homes' </div><div id="bloop_customfont" style="margin: 0px;">INFO: analyzing "demo.homes"</div><div id="bloop_customfont" style="margin: 0px;">INFO: "homes": scanned 2237 of 2237 pages, containing 101937 live rows and 0 dead rows; 30000 rows in sample, 101937 estimated total rows</div><div id="bloop_customfont" style="margin: 0px;">NOTICE: no non-null/empty features, unable to compute statistics</div><div id="bloop_customfont" style="margin: 0px;">NOTICE: no non-null/empty features, unable to compute statistics</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;"><div id="bloop_customfont" style="margin: 0px;">CREATE TABLE demo.homes</div><div id="bloop_customfont" style="margin: 0px;">(</div><div id="bloop_customfont" style="margin: 0px;"> gid integer NOT NULL DEFAULT nextval('demo.homes_gid_seq'::regclass),</div><div id="bloop_customfont" style="margin: 0px;"> geolat numeric,</div><div id="bloop_customfont" style="margin: 0px;"> geolong numeric,</div><div id="bloop_customfont" style="margin: 0px;"> geolevel text,</div><div id="bloop_customfont" style="margin: 0px;"> geonumber integer,</div><div id="bloop_customfont" style="margin: 0px;"> geostreet text,</div><div id="bloop_customfont" style="margin: 0px;"> geocity text,</div><div id="bloop_customfont" style="margin: 0px;"> geocounty text,</div><div id="bloop_customfont" style="margin: 0px;"> geostate text,</div><div id="bloop_customfont" style="margin: 0px;"> zip text,</div><div id="bloop_customfont" style="margin: 0px;"> firstname text,</div><div id="bloop_customfont" style="margin: 0px;"> lastname text,</div><div id="bloop_customfont" style="margin: 0px;"> tiv integer,</div><div id="bloop_customfont" style="margin: 0px;"> geom geometry(PointZM,4326),</div><div id="bloop_customfont" style="margin: 0px;"> CONSTRAINT homes_pkey PRIMARY KEY (gid)</div><div id="bloop_customfont" style="margin: 0px;">)</div><div id="bloop_customfont" style="margin: 0px;"><br></div><div id="bloop_customfont" style="margin: 0px;"><br></div></div></div><br><div><br></div><div><br></div></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>