[postgis-users] Upgrading from PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS 1.0

[Mario Servin]

By the way Stephen, it seems that there's something missed at the new
the_geom column:
in older versions geometry data was stored as
SRID=-1;POINT(-66.046532 -21.951437)
Now the select asewkt shows the following:
POINT(-66.046532 -21.951437)
What happens with SRID?


On 1/20/06, Mario Servin <mservin at gmail.com> wrote:
>
> Thanks Stephen! now I can see them!!. How can I change the default
> behavior for seeing as simple text ?
>
> On 1/20/06, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
> >
> > Mario Servin wrote:
> > > Hi everybody,
> > >
> > [snip]
> > >
> > > Additionally, I still have the results from the old shp2pgsql and so I
> >
> > > tried to insert the data form psql using \i mysqlinsertionscript.sql.
> > > Tables are created ok, but geom columns results in meaningless
> > > characters where it is supossed to be something like "POINT (-
> > 66.046532
> > > -21.951437)" for example.
> >
> > The default behavior changed. Try:
> >
> > select aswkt(the_geom) from table;
> >
> > the default is to display the geometry in a hex representation of the
> > binary.
> >
> > -Steve W.
> >
> > > Can anybody help me?.
> > > Regards,
> > >             Mario Servin
> > >
> > >
> > >
> > ------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060120/299857f5/attachment.html>