[postgis-tickets] r16248 - Change to SPI_execute so we can run SRS query in 'read_only' mode and avoid transaction issues that break parallel mode

[Paul Ramsey]

Author: pramsey
Date: 2018-01-10 06:01:25 -0800 (Wed, 10 Jan 2018)
New Revision: 16248

Modified:
   trunk/libpgcommon/lwgeom_transform.c
Log:
Change to SPI_execute so we can run SRS query in 'read_only' mode and avoid transaction issues that break parallel mode


Modified: trunk/libpgcommon/lwgeom_transform.c
===================================================================
--- trunk/libpgcommon/lwgeom_transform.c	2018-01-10 11:35:22 UTC (rev 16247)
+++ trunk/libpgcommon/lwgeom_transform.c	2018-01-10 14:01:25 UTC (rev 16248)
@@ -338,7 +338,7 @@
 
 	/* Execute the lookup query */
 	snprintf(proj4_spi_buffer, 255, "SELECT proj4text FROM spatial_ref_sys WHERE srid = %d LIMIT 1", srid);
-	spi_result = SPI_exec(proj4_spi_buffer, 1);
+	spi_result = SPI_execute(proj4_spi_buffer, true, 1);
 
 	/* Read back the PROJ4 text */
 	if (spi_result == SPI_OK_SELECT && SPI_processed > 0)