postgis sfcgal test error

[darkblueb]

# ------------------------------------
# create database 'aacgal'
# create extension postgis
# create extension postgis_sfcgal
#
user@osgeolive:~/srcs_local/postgis_github/regress$ \
    psql aacgal -f postgis/regress/sfcgal/geography.sql
SET
psql:sfcgal/geography.sql:10: ERROR:  duplicate key value violates unique constraint "spatial_ref_sys_pkey"
DETAIL:  Key (srid)=(4326) already exists.
            c            | ?column? 
-------------------------+----------
 geog_distance_cached_1a | t
 geog_distance_cached_1b | t
 geog_distance_cached_1c | t
 geog_distance_cached_1e | t
 geog_distance_cached_1f | t
 geog_distance_cached_1g | t
 geog_distance_cached_1h | t
(7 rows)

           c           | st_dwithin 
-----------------------+------------
 geog_dithin_cached_1a | t

...

 geog_precision_pazafir |                    0 |           0
 geog_precision_pazafir |                    0 |           0
(2 rows)

DELETE 1

[kalxas]

Lets check again once we move to postgis 2.2.2 in a few days

[Bas Couwenberg]

PostGIS 2.2.2 is in 10.0 RC1, and the duplicate key error occurs there as well because it tries to insert a record in the postgis spatial_ref_sys table that already exists.

I don't think this issue needs fixing.