commit - 292ef481e4820a1a145202c486965765283d72c3
commit + b430b047ed4d73e08e057b2041e37fb379d3cfa2
blob - 1d2ba62ce7edc3f19a6c1fe3668ad4b649624e6c
blob + 7027c5502b88b827bdea4c2e7524849e72dd2425
--- pg_feedback--1.0.sql
+++ pg_feedback--1.0.sql
@@ -1,10 +1,7 @@
 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
 \echo Use "CREATE EXTENSION pg_feedback" to load this file. \quit
-CREATE OR REPLACE FUNCTION feedback()
+CREATE FUNCTION feedback()
 RETURNS json AS $$
-DECLARE
-result json;
-BEGIN
 	SELECT
 		json_build_object(
 		'uuid', 'XXX-XXX-XXX-XXX',	-- FIXME
@@ -17,11 +14,10 @@ BEGIN
 							name='lc_ctype' OR
 							name='shared_buffers' OR
 							name='work_mem') s),
+		--'extensions', (SELECT json_agg(e) FROM (SELECT extname AS e FROM pg_extension) e),
 		'extensions', (SELECT json_agg(e) FROM
 					(SELECT name,comment,default_version FROM pg_available_extensions) e),
 		'databases_size', (SELECT row_to_json(s) FROM
 					(SELECT SUM(pg_database_size(pg_database.datname)) AS size FROM pg_database) s)
-	) INTO result;
-RETURN result;
-END;
-$$ LANGUAGE sql;
+	);
+  $$ LANGUAGE sql;