[postgis-users] INSERT geom Problem

[Levert Donovan]

Hello, 
I have make a mistake, I have not using Postis 1.0 but
Postgis 0.9.1.

mapcanada=> SELECT postgis_full_version();
                                       
postgis_full_version                    
-----------------------------------------------------------------------------------------------------
 POSTGIS="0.9.1" GEOS="1.0.0" PROJ="Rel. 4.4.8, 3 May
2004" USE_STATS DBPROC="0.0.1" RELPROC="0.0.1"
(1 row)

I solved the problem with shp2pgsql, I used -w option
for the postgis 0.x

Thank you for your responses.

Best Regards.
Donovan


>Just type "select
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);"
at the psql prompt.
ERROR:  couldnt parse objects in GEOMETRY

--- Markus Schaber <schabi at logix-tt.com> a écrit :

> Hi, Levert,
> 
> Levert Donovan wrote:
> 
> > $psql  -U mapuser mapcanada
> > mapcanada=> SELECT version();
> > version
> >
>
---------------------------------------------------------------------------------------------------------
> >  PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled
> by
> > GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0
> 3.2-7)
> > (1 row)
> 
> That looks fine.
> 
> > I can't do the SELECT because the INSERT doesn't
> > works. 
> > select
> >
>
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);
> 
> You do not need any INSERT for this SELECT.
> 
> Just type "select
>
setsrid('0101000000000000A053984241000000C0789A3141'::geometry,27582);"
> at the psql prompt.
> 
> Schabi
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com