[postgis-users] Possible index stats problem?

[strk at refractions.net]

On Tue, Sep 14, 2004 at 10:03:25AM -0300, Alexandre Florio wrote:
> Em Tue, 14 Sep 2004 08:25:34 +0200
> strk at refractions.net escreveu:
> 
> > > > > 4. create lang plpgsql and insert postgis.sql and spatial_ref_sys.sql
> > > > Didn't you get lots of errors in this step ?
> > > No.  Why should I get them?
> > Many objects defined in postgis.sql should already be in your dump.
> > Functions are create-or-replaced, but other objects aren't/can't.
> > For example the cost estimator needs a modification of the Geometry
> > type definition, and that type is (old) in the dump and (new) in
> > the postgis.sql file.
> > I can't belive you didn't get any error (or at least notice) message.
> I didn't because I executed postgis.sql in a new database, and I removed all the old postgis definitions from the dump (forgot to mention).  No "CREATE TYPE" statement in my dump.

Ok. Now I belive you.
Note that utils/postgis_restore.pl does exactly that.
(for the next time).

--strk;