[postgis-users] INSERT geom Problem

[Markus Schaber]

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