[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Retrieving and storing Geography column data
From:       Paul Ramsey <pramsey () opengeo ! org>
Date:       2010-05-21 14:27:28
Message-ID: AANLkTiktjslwsytXoOFZCdxiQMtyuESNzNYzsU18uaz3 () mail ! gmail ! com
[Download RAW message or body]

You should file a ticket on it... I think if you create a function
geography(bytea) that just call the ST_GeogFromWKB() function that
should get around your casting problem.

CREATE OR REPLACE FUNCTION geography(bytea)
        RETURNS geography
        AS 'SELECT ST_GeogFromWKB($1)'
        LANGUAGE 'SQL' IMMUTABLE STRICT;

P

On Fri, May 21, 2010 at 7:00 AM, Kristof Adriaenssens
<kristof.adriaenssens@gmail.com> wrote:
> Hi all,
>
> We used the GeometryType Hibernate UserType that gets delivered with Postgis
> 1.5 (java/ejb3) to store and retrieve Geometry column data.
> This works fine but unfortunately it does not seem to support the new
> Geography data type.
>
> We tried storing Point and LineString Geometry objects (SRID set to 4326)
> but we get an exception that a bytea can't be converted to Geography.
> We use the org.postgis.DriverWrapper Driver class name which is supposed to
> automatically load support for the spatial types.
>
> Is there a known work-around that would work for us, preferably through
> JDBC?  If not now then are there plans to support this?
>
> Thank you!
> Kristof
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]