[Postgres-xl-bugs] postgis support

Mason Sharp msharp at translattice.com
Mon Nov 3 17:05:28 PST 2014


Hi Junqi,

Thank you for submitting this.

This will need more investigation when we have time. For now I have created
a ticket for it:

https://sourceforge.net/p/postgres-xl/tickets/36/

Regards,

Mason


On Fri, Oct 31, 2014 at 12:02 PM, Yin, Junqi <jyin8 at utk.edu> wrote:

>  Hello,
>
>
>
> I’ve been using Postgres-XL with PostGIS, and found the following error,
>
>
>
> -- Executing query:
>
> select t.gid as id, ST_Transform(t.geom, 4326) as geom from us_town t
>
> ERROR:  GetProj4StringSPI: Cannot find SRID (102003) in spatial_ref_sys
>
>
>
> But in fact both SRID (4326 and 102003) are in spatial_ref_sys table.
>
>
>
> -- Executing query:
>
> select * from spatial_ref_sys where srid=102003 or srid=4326
>
> Total query runtime: 272 ms.
>
> 2 rows retrieved.
>
>
>
> Also “select t.gid as id, ST_Transform(t.geom, 102003) as geom from
> us_town t” works fine, and the above queries work in PostgreSQL 9.3.5 +
> PostGIS 2.1.4.
>
>
>
> Here is some information about my installation:
>
>
>
> PostgreSQL 9.2.4 (Postgres-XL 9.2.0) on x86_64-unknown-linux-gnu, compiled
> by gcc (GCC) 4.8.2, 64-bit
>
> Postgis 2.0.6 - r12554 - 2014-10-24 17:49:59
>
> GEOS: 3.4.2-CAPI-1.8.2 r3921
>
> PROJ: Rel. 4.8.0, 6 March 2012
>
>
>
> BTW, the “make check” failed in PostGIS 2.0.6, but it seems to be
> something else.
>
>
>
> Thanks,
>
> Junqi
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Postgres-xl-bugs mailing list
> Postgres-xl-bugs at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-bugs
>
>


-- 
Mason Sharp

TransLattice - http://www.translattice.com
Clustered and Distributed Database Solutions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20141103/abb6efd5/attachment.htm>


More information about the postgres-xl-bugs mailing list