[postgis-tickets] r16968 - Fix sfcgal regress failure - Delete 4326 entry before readding. Also use integer format instead of string format.

[Regina Obe]

Author: robe
Date: 2018-10-30 20:25:23 -0700 (Tue, 30 Oct 2018)
New Revision: 16968

Modified:
   trunk/regress/sfcgal/geography.sql
Log:
Fix sfcgal regress failure - Delete 4326 entry before readding. Also use integer format instead of string format.
References #4210

Modified: trunk/regress/sfcgal/geography.sql
===================================================================
--- trunk/regress/sfcgal/geography.sql	2018-10-30 21:37:12 UTC (rev 16967)
+++ trunk/regress/sfcgal/geography.sql	2018-10-31 03:25:23 UTC (rev 16968)
@@ -1,10 +1,11 @@
 SET postgis.backend = 'sfcgal';
 
+DELETE FROM spatial_ref_sys where srid = 4326;
 INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text)
 VALUES (
- '4326',
+ 4326,
  'EPSG',
- '4326',
+ 4326,
  'GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]',
  '+proj=longlat +datum=WGS84 +no_defs'
 );