#36 Postgres-XL and PostGIS

[mason_s]

Submitted by Junqi Yin:

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.