Re: 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: Re: ANALYZE errors (postgres 8.1.4)
Date: 2006-12-06 15:34:40
Message-ID: 1165419280.5249.27.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)bowden(at)westnet(dot)com(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message K. Kelly Close 2006-12-07 00:00:10 PostgreSQL back end to Excel ap
Previous Message Michael Fuhr 2006-12-06 15:21:46 Re: ANALYZE errors (postgres 8.1.4)