Skip site navigation (1) Skip section navigation (2)

ANALYZE errors (postgres 8.1.4)

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 (view raw or flat)
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


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-12-06 15:15:21
Subject: Re: ANALYZE errors (postgres 8.1.4)
Previous:From: Greg QuinnDate: 2006-12-05 19:28:44
Subject: Default install options for silent install on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group