[postgis-tickets] r14291 - closes #3340 for 2.2 support for foreign tables in populate_geometry_columns

SVN on behalf of Regina Obe lr at pcorp.us
Mon Oct 19 11:50:06 PDT 2015


Author: robe
Date: 2015-10-19 11:50:06 -0700 (Mon, 19 Oct 2015)
New Revision: 14291

Modified:
   branches/2.2/postgis/postgis.sql.in
Log:
closes #3340 for 2.2 support for foreign tables in populate_geometry_columns

Modified: branches/2.2/postgis/postgis.sql.in
===================================================================
--- branches/2.2/postgis/postgis.sql.in	2015-10-19 10:52:10 UTC (rev 14290)
+++ branches/2.2/postgis/postgis.sql.in	2015-10-19 18:50:06 UTC (rev 14291)
@@ -1922,7 +1922,7 @@
 		 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 @@
 			 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 @@
 			 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



More information about the postgis-tickets mailing list