Launchpad itself

Merge ~wgrant/launchpad:pg10-stattuple-perms into launchpad:master

  1. Git
  2. lp:~wgrant/launchpad
  3. pg10-stattuple-perms
  4. Merge into master
Proposed by William Grant
Status: Merged
Approved by: William Grant
Approved revision: d8b9a7ead66a31a9b6e80045ad3390c41d02f6b3
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~wgrant/launchpad:pg10-stattuple-perms
Merge into: launchpad:master
Diff against target: 21 lines (+7/-2)
1 file modified
database/schema/security.cfg (+7/-2)
Reviewer Review Type Date Requested Status
Colin Watson (community) db Approve
Review via email: mp+380003@code.launchpad.net

Commit message

Update security.cfg for PostgreSQL 10's pgstattuple

Description of the change

Just eliminates security.py warnings.

To post a comment you must log in.
Revision history for this message
Colin Watson (cjwatson) wrote :

Thanks, I've been meaning to sort this out for so long ...

review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1diff --git a/database/schema/security.cfg b/database/schema/security.cfg
2index 5894f34..306d206 100644
3--- a/database/schema/security.cfg
4+++ b/database/schema/security.cfg
5@@ -62,9 +62,14 @@ public.min(debversion) = EXECUTE
6 public.name_blacklist_match(text, integer) = EXECUTE
7 public.null_count(anyarray) = EXECUTE
8 public.person_sort_key(text, text) = EXECUTE
9-public.pgstattuple(oid) =
10-public.pgstattuple(text) =
11+public.pgstatginindex(regclass) =
12+public.pgstathashindex(regclass) =
13+public.pgstatindex(regclass) =
14 public.pgstatindex(text) =
15+public.pgstattuple(regclass) =
16+public.pgstattuple(text) =
17+public.pgstattuple_approx(regclass) =
18+public.pg_relpages(regclass) =
19 public.pg_relpages(text) =
20 public.pillarname = SELECT
21 public.replication_lag() = EXECUTE

Subscribers

People subscribed via source and target branches

to status/vote changes: