[postgis-users] Differences between postgis on Windows and Unix?

[strk at refractions.net]

The missing columns in geometry_columns are due to postgresql 8.0
making them unneeded (it supports used-defined statistical analisys).

You should first install postgres, then postgis, then restore the
dump (and this last step whould give you the warnings/errors).

--strk;

On Thu, Jan 27, 2005 at 10:19:31PM +0100, Benjamin Thelen wrote:
> Hi,
> 
> I installed postgresql-8.0-release on Windows, selected postgis, too and
> tried to import (first COPY, then INSERT) data, which I had dumped from
> postgresql-7.3.8/postgis-0.8.1. Usually, importing data caused messages
> like "function already existing", but nevertheless it worked. Not so with
> the windows postgres/postgis. Nothing was imported, even no table created.
> 
> I found out, that three columns are missing in "geometry_columns":
> attrelid oid
> varattnum int4
> stats histogram2d
> 
> 
> I added the missing columns manually, manipulated the dump manually, but
> without success importing the data cleanly. I wouldn't really mind, but I
> can't display the postgis-data with mapserver.
> 
> I then downloaded Windows postgis 0.9.1, reinstalled postgres without
> postgis, but it the same.
> 
> 
> I searched google and the list, but I don't get an idea.
> 
> Can somebody help, give me a hint?
> 
> Thanks,
> Benjamin
> 
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users