[postgis-tickets] r17218 - Flip to 30 table suffix
Regina Obe
lr at pcorp.us
Sat Jan 26 03:22:52 PST 2019
Author: robe
Date: 2019-01-26 15:22:52 -0800 (Sat, 26 Jan 2019)
New Revision: 17218
Modified:
trunk/doc/xsl/postgis_gardentest.sql.xsl
trunk/doc/xsl/raster_gardentest.sql.xsl
trunk/doc/xsl/topology_gardentest.sql.xsl
Log:
Flip to 30 table suffix
Modified: trunk/doc/xsl/postgis_gardentest.sql.xsl
===================================================================
--- trunk/doc/xsl/postgis_gardentest.sql.xsl 2019-01-26 18:40:44 UTC (rev 17217)
+++ trunk/doc/xsl/postgis_gardentest.sql.xsl 2019-01-26 23:22:52 UTC (rev 17218)
@@ -8,7 +8,7 @@
using a garden variety of geometries. Its intent is to flag major crashes.
******************************************************************** -->
<xsl:output method="text" />
- <xsl:variable name='testversion'>2.5.0</xsl:variable>
+ <xsl:variable name='testversion'>3.0.0</xsl:variable>
<xsl:variable name='fnexclude14'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
<xsl:variable name='fnexclude'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
<!--This is just a place holder to state functions not supported or tested separately -->
@@ -33,7 +33,7 @@
<xsl:variable name='var_matrix'>'FF1FF0102'</xsl:variable>
<xsl:variable name='var_boolean'>false</xsl:variable>
<xsl:variable name='var_geom_name'>the_geom</xsl:variable>
- <xsl:variable name='var_logtable'>postgis_garden_log25</xsl:variable>
+ <xsl:variable name='var_logtable'>postgis_garden_log30</xsl:variable>
<xsl:variable name='var_logupdatesql'>UPDATE <xsl:value-of select="$var_logtable" /> SET log_end = clock_timestamp()
FROM (SELECT logid FROM <xsl:value-of select="$var_logtable" /> ORDER BY logid DESC limit 1) As foo
WHERE <xsl:value-of select="$var_logtable" />.logid = foo.logid AND <xsl:value-of select="$var_logtable" />.log_end IS NULL;</xsl:variable>
Modified: trunk/doc/xsl/raster_gardentest.sql.xsl
===================================================================
--- trunk/doc/xsl/raster_gardentest.sql.xsl 2019-01-26 18:40:44 UTC (rev 17217)
+++ trunk/doc/xsl/raster_gardentest.sql.xsl 2019-01-26 23:22:52 UTC (rev 17218)
@@ -8,7 +8,7 @@
using a garden variety of rasters. Its intent is to flag major crashes.
******************************************************************** -->
<xsl:output method="text" />
- <xsl:variable name='testversion'>2.5.0</xsl:variable>
+ <xsl:variable name='testversion'>3.0.0</xsl:variable>
<xsl:variable name='fnexclude'>AddRasterColumn AddRasterConstraints DropRasterConstraints DropRasterColumn DropRasterTable</xsl:variable>
<!--This is just a place holder to state functions not supported in 1.3 or tested separately -->
@@ -31,7 +31,7 @@
<xsl:variable name='var_rastercolumn'>'rast'</xsl:variable>
<xsl:variable name='var_rastertable'>'pgis_rgarden_1bb'</xsl:variable>
<xsl:variable name='var_boolean'>false</xsl:variable>
- <xsl:variable name='var_logtable'>raster_garden_log25</xsl:variable>
+ <xsl:variable name='var_logtable'>raster_garden_log30</xsl:variable>
<xsl:variable name='var_pixeltypes'>{8BUI,1BB}</xsl:variable>
<xsl:variable name='var_pixelvalues'>{255,0}</xsl:variable>
<xsl:variable name='var_algorithm'>'Lanczos'</xsl:variable>
Modified: trunk/doc/xsl/topology_gardentest.sql.xsl
===================================================================
--- trunk/doc/xsl/topology_gardentest.sql.xsl 2019-01-26 18:40:44 UTC (rev 17217)
+++ trunk/doc/xsl/topology_gardentest.sql.xsl 2019-01-26 23:22:52 UTC (rev 17218)
@@ -27,7 +27,7 @@
<xsl:variable name='var_spheroid'>'SPHEROID["GRS_1980",6378137,298.257222101]'</xsl:variable>
<xsl:variable name='var_matrix'>'FF1FF0102'</xsl:variable>
<xsl:variable name='var_boolean'>false</xsl:variable>
- <xsl:variable name='var_logtable'>postgis_topology_garden_log21</xsl:variable>
+ <xsl:variable name='var_logtable'>postgis_topology_garden_log30</xsl:variable>
<xsl:variable name='var_logupdatesql'>UPDATE <xsl:value-of select="$var_logtable" /> SET log_end = clock_timestamp()
FROM (SELECT logid FROM <xsl:value-of select="$var_logtable" /> ORDER BY logid DESC limit 1) As foo
WHERE <xsl:value-of select="$var_logtable" />.logid = foo.logid AND <xsl:value-of select="$var_logtable" />.log_end IS NULL;</xsl:variable>
More information about the postgis-tickets
mailing list