grant select on all views to public

funbringer · funbringer · commit f4e71de5a689 · 2016-10-07T22:43:47.000+03:00
diff --git a/init.sql b/init.sql
@@ -199,6 +199,8 @@ AS 'pg_pathman', 'show_partition_list_internal' LANGUAGE C STRICT;
 CREATE OR REPLACE VIEW @extschema@.pathman_partition_list
 AS SELECT * FROM @extschema@.show_partition_list();
 
+GRANT SELECT ON @extschema@.pathman_partition_list TO PUBLIC;
+
 /*
  * Show all existing concurrent partitioning tasks.
  */
@@ -218,6 +220,8 @@ AS 'pg_pathman', 'show_concurrent_part_tasks_internal' LANGUAGE C STRICT;
 CREATE OR REPLACE VIEW @extschema@.pathman_concurrent_part_tasks
 AS SELECT * FROM @extschema@.show_concurrent_part_tasks();
 
+GRANT SELECT ON @extschema@.pathman_concurrent_part_tasks TO PUBLIC;
+
 /*
  * Partition table using ConcurrentPartWorker.
  */
diff --git a/src/pl_funcs.c b/src/pl_funcs.c
@@ -587,7 +587,7 @@ add_to_pathman_config(PG_FUNCTION_ARGS)
 		elog(ERROR, "Invalid relation %u", relid);
 
 	if (get_attnum(relid, text_to_cstring(attname)) == InvalidAttrNumber)
-		elog(ERROR, "Relation \"%s\" has no column '%s'",
+		elog(ERROR, "relation \"%s\" has no column \"%s\"",
 			 get_rel_name_or_relid(relid), text_to_cstring(attname));
 
 	/* Select partitioning type using 'range_interval' */
