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

Re: ANALYZE errors (postgres 8.1.4)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tim Bowden <tim(dot)bowden(at)westnet(dot)com(dot)au>, pgsql-novice(at)postgresql(dot)org
Subject: Re: ANALYZE errors (postgres 8.1.4)
Date: 2006-12-06 15:21:46
Message-ID: 20061206152146.GA59631@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
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

-- 
Michael Fuhr

In response to

Responses

pgsql-novice by date

Next:From: Tim BowdenDate: 2006-12-06 15:34:40
Subject: Re: ANALYZE errors (postgres 8.1.4)
Previous:From: Tom LaneDate: 2006-12-06 15:15:21
Subject: Re: ANALYZE errors (postgres 8.1.4)

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