Opened 3 years ago

Closed 3 years ago

#1727 closed defect (wontfix)

postgis sfcgal test error

Reported by: darkblueb Owned by: live-demo@…
Priority: minor Milestone: OSGeoLive10.0
Component: OSGeoLive Keywords: postgis, sfcgal
Cc:

Description

# ------------------------------------
# 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

Change history (3)

comment:1 Changed 3 years ago by kalxas

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

comment:2 Changed 3 years ago by 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.

comment:3 Changed 3 years ago by darkblueb

Resolution: wontfix
Status: newclosed
Note: See TracTickets for help on using tickets.