William Grant has proposed merging lp:~wgrant/launchpad/postgresql-10-db into
lp:launchpad with lp:~wgrant/launchpad/no-tsearch2 as a prerequisite.
Commit message:
Update activity() for PostgreSQL 10 support, in addition to 9.6, 9.5 and 9.3.
Requested reviews:
Launchpad code reviewers (launchpad-reviewers)
For more details, see:
https://code.launchpad.net/~wgrant/launchpad/postgresql-10-db/+merge/345516
Update activity() for PostgreSQL 10 support, in addition to 9.6, 9.5 and 9.3.
--
Your team Launchpad code reviewers is requested to review the proposed merge of
lp:~wgrant/launchpad/postgresql-10-db into lp:launchpad.
=== added file 'database/schema/patch-2209-84-1.sql'
--- database/schema/patch-2209-84-1.sql 1970-01-01 00:00:00 +
+++ database/schema/patch-2209-84-1.sql 2018-05-14 11:26:32 +
@@ -0,0 +1,94 @@
+-- Copyright 2018 Canonical Ltd. This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages = ERROR;
+
+-- Update functions for PostgreSQL 10 support, in addition to 9.6, 9.5 and 9.3.
+
+-- From 2209-81-0
+CREATE OR REPLACE FUNCTION activity()
+RETURNS SETOF pg_stat_activity
+VOLATILE SECURITY DEFINER SET search_path = public
+LANGUAGE plpgsql AS $$
+DECLARE
+a pg_stat_activity%ROWTYPE;
+BEGIN
+IF EXISTS (
+SELECT 1 FROM pg_attribute WHERE
+attrelid =
+(SELECT oid FROM pg_class
+ WHERE relname = 'pg_stat_activity')
+AND attname = 'backend_type') THEN
+-- >= 10
+RETURN QUERY SELECT
+datid, datname, pid, usesysid, usename, application_name,
+client_addr, client_hostname, client_port, backend_start,
+xact_start, query_start, state_change, wait_event_type,
+wait_event, state, backend_xid, backend_xmin, backend_type,
+CASE
+WHEN query LIKE '%'
+OR query LIKE 'autovacuum:%'
+THEN query
+ELSE
+''
+END AS query
+FROM pg_catalog.pg_stat_activity;
+ELSIF EXISTS (
+SELECT 1 FROM pg_attribute WHERE
+attrelid =
+(SELECT oid FROM pg_class
+ WHERE relname = 'pg_stat_activity')
+AND attname = 'wait_event_type') THEN
+-- >= 9.6
+RETURN QUERY SELECT
+datid, datname, pid, usesysid, usename, application_name,
+client_addr, client_hostname, client_port, backend_start,
+xact_start, query_start, state_change, wait_event_type,
+wait_event, state, backend_xid, backend_xmin,
+CASE
+WHEN query LIKE '%'
+OR query LIKE 'autovacuum:%'
+THEN query
+ELSE
+''
+END AS query
+FROM pg_catalog.pg_stat_activity;
+ELSIF EXISTS (
+SELECT 1 FROM pg_attribute WHERE
+attrelid =
+(SELECT oid FROM pg_class
+ WHERE relname = 'pg_stat_activity')
+AND attname = 'backend_xid') THEN
+-- >= 9.4
+RETURN QUERY SELECT
+datid, datname, pid, usesysid, usename, application_name,
+client_addr, client_hostname, client_port, backend_start,
+xact_start, query_start, state_change, waiting, state,
+backend_xid, backend_xmin,
+CASE
+WHEN query LIKE '%'
+OR query LIKE 'autovacuum:%'
+THEN query
+ELSE
+''
+END AS query
+FROM pg_catalog.pg_stat_activity;
+ELSE
+-- >= 9.2; anything older is unsupported
+RETURN QUERY SELECT
+datid, datname, pid, usesysid, usename, application_name,
+client_addr, client_hostname, client_port, backend_start,
+xact_start, query_start, state_change, waiting, state,
+CASE
+WHEN query LIKE '%'
+OR query LIKE 'autovacuum:%'
+THEN query
+ELSE
+''
+END AS query
+FROM pg_catalog.pg_stat_activity;
+END IF;
+END;
+$$;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 84, 1);
___
Mailing list: https://launchpad.net/~launchpad-reviewers
Post to : launchpad-reviewers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~launchpad-reviewers
More help : https://help.launchpad.net/ListHelp
