From: | Tim Bowden <tim(dot)bowden(at)westnet(dot)com(dot)au> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | ANALYZE errors (postgres 8.1.4) |
Date: | 2006-12-06 13:31:45 |
Message-ID: | 1165411905.5249.9.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm having some problems with ANALYZE.
When I run ANALYZE on a postgis enabled database created by ogr2ogr from
the Census Bureau's tiger data I get the following error for a number of
the tables created:
tiger2005se=# ANALYZE arealandmarks ;
NOTICE: no notnull values, invalid stats
I can't find any reference to this error. What does it mean?
Table structure:
tiger2005se=# \d arealandmarks
Table "public.arealandmarks"
Column | Type | Modifiers
--------------+---------------+-----------------------------------------------------------------
ogc_fid | integer | not null default
nextval('arealandmarks_ogc_fid_seq'::regclass)
wkb_geometry | geometry |
module | character(8) |
file | character(5) |
state | numeric(2,0) |
county | numeric(3,0) |
cenid | character(5) |
polyid | numeric(10,0) |
land | numeric(10,0) |
Indexes:
"indx_mod_arealandmarks" btree (module)
Check constraints:
"enforce_dims_wkb_geometry" CHECK (ndims(wkb_geometry) = 2)
"enforce_srid_wkb_geometry" CHECK (srid(wkb_geometry) = 32767)
Thanks,
Tim Bowden
Mapforge Geospatial
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-12-06 15:15:21 | Re: ANALYZE errors (postgres 8.1.4) |
Previous Message | Greg Quinn | 2006-12-05 19:28:44 | Default install options for silent install on Windows |