From a3e61a7444f77ce12eab9eddcd8031c61ef98fa2 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Mon, 19 Oct 2015 04:16:25 +0000 Subject: [PATCH] addresses #3340 for 2.3 support for foreign tables in populate_geometry_columns git-svn-id: http://svn.osgeo.org/postgis/trunk@14288 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/postgis.sql.in | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in index 46bb4cfe1..e8385d4e2 100644 --- a/postgis/postgis.sql.in +++ b/postgis/postgis.sql.in @@ -1922,7 +1922,7 @@ BEGIN pg_attribute a, pg_type t, pg_namespace n - WHERE (c.relkind = 'r' OR c.relkind = 'v') + WHERE (c.relkind IN('r','v','f') AND t.typname = 'geometry' AND a.attisdropped = false AND a.atttypid = t.oid @@ -1939,7 +1939,7 @@ BEGIN pg_attribute a, pg_type t, pg_namespace n - WHERE c.relkind = 'r' + WHERE c.relkind IN( 'r', 'f') AND t.typname = 'geometry' AND a.attisdropped = false AND a.atttypid = t.oid @@ -2010,7 +2010,7 @@ BEGIN pg_attribute a, pg_type t, pg_namespace n - WHERE c.relkind = 'r' + WHERE c.relkind IN('r', 'f') AND t.typname = 'geometry' AND a.attisdropped = false AND a.atttypid = t.oid -- 2.40.0