From a477824900b909f8e3cb5262dbfe3359c49f56db Mon Sep 17 00:00:00 2001 From: Bborie Park Date: Sat, 19 Oct 2013 17:12:02 +0000 Subject: [PATCH] Support materialized views and foreign tables in raster_columns and raster_overviews. Ticket #2512 git-svn-id: http://svn.osgeo.org/postgis/trunk@12051 b70326c6-7e19-0410-871a-916f4a2858ee --- NEWS | 2 ++ raster/rt_pg/rtpostgis.sql.in | 4 ++-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/NEWS b/NEWS index 65f19c24f..551cf9331 100644 --- a/NEWS +++ b/NEWS @@ -29,6 +29,8 @@ PostGIS 2.2.0 - #2454, Fix behavior of ST_PixelAsXXX functions regarding exclude_nodata_value parameter - #2493, Fix behavior of ST_DumpValues when passed an empty raster + - #2512, Support for foreign tables and materialized views in + raster_columns and raster_overviews PostGIS 2.1.0 2013/08/17 diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in index c67b25dc6..625402305 100644 --- a/raster/rt_pg/rtpostgis.sql.in +++ b/raster/rt_pg/rtpostgis.sql.in @@ -7951,7 +7951,7 @@ CREATE OR REPLACE VIEW raster_columns AS AND a.atttypid = t.oid AND a.attrelid = c.oid AND c.relnamespace = n.oid - AND (c.relkind = 'r'::"char" OR c.relkind = 'v'::"char") + AND c.relkind = ANY(ARRAY['r'::char, 'v'::char, 'm'::char, 'f'::char]) AND NOT pg_is_other_temp_schema(c.relnamespace); ------------------------------------------------------------------------------ @@ -8051,7 +8051,7 @@ CREATE OR REPLACE VIEW raster_overviews AS AND a.atttypid = t.oid AND a.attrelid = c.oid AND c.relnamespace = n.oid - AND (c.relkind = 'r'::"char" OR c.relkind = 'v'::"char") + AND c.relkind = ANY(ARRAY['r'::char, 'v'::char, 'm'::char, 'f'::char]) AND s.connamespace = n.oid AND s.conrelid = c.oid AND s.consrc LIKE '%_overview_constraint(%' -- 2.50.1