Re: ANALYZE errors (postgres 8.1.4) - Mailing list pgsql-novice

From Tim Bowden
Subject Re: ANALYZE errors (postgres 8.1.4)
Date
Msg-id 1165419280.5249.27.camel@localhost
Whole thread Raw
In response to Re: ANALYZE errors (postgres 8.1.4)  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Thanks Tom & Michael,

Now I know where it comes from I can deal with it sensibly.

Regards,
Tim Bowden

On Wed, 2006-12-06 at 08:21 -0700, Michael Fuhr wrote:
> On Wed, Dec 06, 2006 at 10:15:21AM -0500, Tom Lane wrote:
> > Tim Bowden <tim.bowden@westnet.com.au> writes:
> > > 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
> >
> > You'd have to ask the PostGIS people --- there is no such error message
> > in the base Postgres distribution, so I suppose it must be theirs.
>
> Yes, this is a PostGIS message.
>
> http://archives.postgresql.org/pgsql-sql/2006-02/msg00052.php
>


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ANALYZE errors (postgres 8.1.4)
Next
From: "K. Kelly Close"
Date:
Subject: PostgreSQL back end to Excel ap