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

Re: Analyze Explanation

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Willem Buitendyk <willem(at)pcfish(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Analyze Explanation
Date: 2008-01-29 19:48:52
Message-ID: 20080129194852.GA93163@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Jan 29, 2008 at 10:11:38AM -0800, Willem Buitendyk wrote:
> When I run Analyze I get the following notice repeated for many of my 
> tables:
> 
> NOTICE:   no notnull values, invalid stats
> 
> Is this just refering to my empty tables?

The PostGIS function compute_geometry_stats() logs such a message.
I'd guess you're using PostGIS and those tables have NULL in all
rows' geometry columns.

-- 
Michael Fuhr

In response to

pgsql-general by date

Next:From: A.M.Date: 2008-01-29 20:16:41
Subject: Re: OT - pg perl DBI question
Previous:From: Tom LaneDate: 2008-01-29 19:47:11
Subject: Re: Table has duplicate keys, what did I do

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