[postgis-users] Possible index stats problem?

[Alexandre Florio]

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.

-- Alexandre