[postgis-users] postgis upgrade failure

[Nicolas Ribot]

Hi Gabriele.

I think the warnings are normal.
The best proof is that you're able to store and get some geometries.

Internal representation of geometries has changed in postgis 1.0. It
now uses binary format.

To get a human-readable format, use some conversion functions, like asText().
This internal representation is faster than the previous one.

Nicolas

On 9/6/05, Gabriele Carteni <gabriele.carteni at unile.it> wrote:
> 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!"
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>