As far as I know, this is due to having a geometry column in a table
where the field is null for all rows. ANALYZE tries to gather stats on
the column, but there aren't any geometries from which to gather stats.
If you ANALYZE VERBOSE, you'll be able to tell which tables have all
null geometry columns.
ie.
kneufeld=# create table public.tmp (id integer, geom geometry);
CREATE TABLE
kneufeld=# insert into tmp (id) values (1);
INSERT 0 1
kneufeld=# ANALYZE tmp;
INFO: analyzing "public.tmp"
INFO: "tmp": scanned 1 of 1 pages, containing 1 live rows and 0 dead
rows; 1 rows in sample, 1 estimated total rows
NOTICE: no notnull values, invalid stats
ANALYZE
Hope this clarifies things,
-- Kevin
-------------
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7
Phone: (250) 383-3022
Email: [EMAIL PROTECTED]
Willem Buitendyk wrote:
I originally posted this in Postgresql mailing list and the reply is
that this is a PostGis matter:
When I run Analyze I get the following notice repeated for many of my
tables:
NOTICE: no notnull values, invalid stats
Is this just refering to my empty tables?
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
