[postgis-users] postgis upgrade failure

[Gabriele Carteni]

hi all,
i've recently upgraded  my postgresql-postgis installation:
from postgresql 8.0beta5 and postgis 0.9
to postgresql  8.0.3  and postgis 1.0.3
....
i didn't have any compilation problem .. but when i made the loading of 
lwpostgis.sql, this error appeared:

psql:lwpostgis.sql:36: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.

the same error appeared for the other spatial data types...

After i've created a spatial enabled database with this table:
CREATE TABLE geotest (id INT4, name VARCHAR(32) );

and i've performed this query:
INSERT INTO geotest (id, name, geopoint) VALUES (1, 'Olympia', 
GeometryFromText('POINT(-122.90 46.97)',1));

no errors founded but now i see this record:
id:1
name:Olympia
geopoint:0101000020010000009A99999999B95EC05C8FC2F5287C4740

with the previous installation i saw an human readable value like 
"SRID=-1;POINT(18.076389 40.226111)"

So... now the question:
is there any error in my new installation??
The alerts after the loading of lwpostgis.sql are normal??
And... this values for geometry data types are correct??

thank you very much in advance.
best regards

gabriele


-- 
_____________________________________________________________
Ing. Gabriele Carteni
Center for Advanced Computational Technologies / ISUFI
University of Lecce, Italy 

office: +39.0832.298.122
ICQ#: 128087012

gpg --recv-keys --keyserver pgp.mit.edu 0x2C8CC857

"Microsoft isn't the answer. Microsoft is the question, and my answer is no!"