From e105d93474792db7ba802ccf00c47ee6e10b983b Mon Sep 17 00:00:00 2001 From: Bborie Park Date: Thu, 15 Dec 2011 00:21:31 +0000 Subject: [PATCH] Renamed st_bytea to bytea as per PostGIS convention. Existing databases will not be affected if upgraded using the upgrade scripts. Associated ticket is #1003 git-svn-id: http://svn.osgeo.org/postgis/trunk@8423 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in.c | 8 ++++---- raster/rt_pg/rtpostgis_drop.sql.in.c | 6 ++++++ raster/test/regress/rt_bytea.sql | 8 ++++---- 3 files changed, 14 insertions(+), 8 deletions(-) diff --git a/raster/rt_pg/rtpostgis.sql.in.c b/raster/rt_pg/rtpostgis.sql.in.c index 0684e96c4..eb271654d 100644 --- a/raster/rt_pg/rtpostgis.sql.in.c +++ b/raster/rt_pg/rtpostgis.sql.in.c @@ -2804,12 +2804,12 @@ CREATE OR REPLACE FUNCTION ST_MinPossibleVal(pixeltype text) CREATE OR REPLACE FUNCTION st_asbinary(raster) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_to_binary' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'C' IMMUTABLE STRICT; -CREATE OR REPLACE FUNCTION st_bytea(raster) +CREATE OR REPLACE FUNCTION bytea(raster) RETURNS bytea AS 'MODULE_PATHNAME', 'RASTER_to_bytea' - LANGUAGE 'C' IMMUTABLE; + LANGUAGE 'C' IMMUTABLE STRICT; ------------------------------------------------------------------------------ -- Casts @@ -2822,7 +2822,7 @@ CREATE CAST (raster AS geometry) WITH FUNCTION st_convexhull(raster) AS IMPLICIT; CREATE CAST (raster AS bytea) - WITH FUNCTION st_bytea(raster) AS IMPLICIT; + WITH FUNCTION bytea(raster) AS IMPLICIT; ------------------------------------------------------------------------------ -- GiST index OPERATOR support functions diff --git a/raster/rt_pg/rtpostgis_drop.sql.in.c b/raster/rt_pg/rtpostgis_drop.sql.in.c index 949a31067..9e14ae2e1 100644 --- a/raster/rt_pg/rtpostgis_drop.sql.in.c +++ b/raster/rt_pg/rtpostgis_drop.sql.in.c @@ -51,6 +51,12 @@ DROP OPERATOR IF EXISTS ~ (raster, raster); DROP FUNCTION IF EXISTS st_contain(raster, raster); */ +-- drop st_bytea +/* commented out for Regina's consideration +DROP CAST IF EXITS (raster as bytea); +DROP FUNCTION IF EXISTS st_bytea(raster); +*/ + -- drop box2d /* commented out for Regina's consideration DROP CAST IF EXISTS (raster AS box2d); diff --git a/raster/test/regress/rt_bytea.sql b/raster/test/regress/rt_bytea.sql index 47965d24c..08458d13d 100644 --- a/raster/test/regress/rt_bytea.sql +++ b/raster/test/regress/rt_bytea.sql @@ -16,9 +16,9 @@ SELECT name FROM rt_bytea_test WHERE - encode(st_bytea(rast), 'hex') != encode(rast::bytea, 'hex') + encode(bytea(rast), 'hex') != encode(rast::bytea, 'hex') OR - encode(st_bytea(rast), 'hex') != encode(rast, 'hex') + encode(bytea(rast), 'hex') != encode(rast, 'hex') ; ----------------------------------------------------------------------- @@ -30,9 +30,9 @@ SELECT name FROM rt_bytea_test WHERE - encode(st_bytea(rast), 'base64') != encode(rast::bytea, 'base64') + encode(bytea(rast), 'base64') != encode(rast::bytea, 'base64') OR - encode(st_bytea(rast), 'base64') != encode(rast, 'base64') + encode(bytea(rast), 'base64') != encode(rast, 'base64') ; ----------------------------------------------------------------------- -- 2.40.0