From b1266f20c949070e3a51a8226f2e008c45329f0a Mon Sep 17 00:00:00 2001 From: Paul Ramsey Date: Wed, 16 Oct 2013 22:43:14 +0000 Subject: [PATCH] #2511 geometry_columns doesn't support materialized views git-svn-id: http://svn.osgeo.org/postgis/trunk@12040 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/postgis.sql.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in index 6caa6c19a..a854e56a4 100644 --- a/postgis/postgis.sql.in +++ b/postgis/postgis.sql.in @@ -4766,7 +4766,7 @@ CREATE OR REPLACE VIEW geometry_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 = 'r'::"char" OR c.relkind = 'v'::"char" OR c.relkind = 'm'::"char") AND NOT pg_is_other_temp_schema(c.relnamespace) AND NOT ( n.nspname = 'public' AND c.relname = 'raster_columns' ) AND has_table_privilege( c.oid, 'SELECT'::text ); -- 2.40.0