diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-04-13 11:35:22 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-04-13 11:35:22 -0300 |
| commit | 3d5facfd9ab66c819ed583b2614b0560405a6aa2 (patch) | |
| tree | 9f9dae6b8970b4764141bd236c07a109d1470ea2 /src | |
| parent | 06fc54cd4355caf8e271ffc864885ccaa879159e (diff) | |
| download | postgresql-3d5facfd9ab66c819ed583b2614b0560405a6aa2.tar.gz postgresql-3d5facfd9ab66c819ed583b2614b0560405a6aa2.zip | |
Remove pg_stats_ext view
It was created as equivalent of pg_stats, but since the code underlying
pg_statistic_ext is more convenient than the one for pg_statistic,
pg_stats_ext is no longer useful.
Author: David Rowley
Reviewed-by: Tomas Vondra
Discussion: https://postgr.es/m/CAKJS1f9zAkPUf9nQrqpFBAsrOHvb5eYa2FVNsmCJy1wegcO_TQ@mail.gmail.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 11 | ||||
| -rw-r--r-- | src/test/regress/expected/rules.out | 9 |
2 files changed, 0 insertions, 20 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 500221ae770..421d51db471 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -186,17 +186,6 @@ CREATE OR REPLACE VIEW pg_sequences AS WHERE NOT pg_is_other_temp_schema(N.oid) AND relkind = 'S'; -CREATE VIEW pg_stats_ext AS - SELECT - N.nspname AS schemaname, - C.relname AS tablename, - S.staname AS staname, - S.stakeys AS attnums, - length(s.standistinct::bytea) AS ndistbytes, - length(S.stadependencies::bytea) AS depsbytes - FROM (pg_statistic_ext S JOIN pg_class C ON (C.oid = S.starelid)) - LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace); - CREATE VIEW pg_stats WITH (security_barrier) AS SELECT nspname AS schemaname, diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index b2779d9698a..409692d6957 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -2188,15 +2188,6 @@ pg_stats| SELECT n.nspname AS schemaname, JOIN pg_attribute a ON (((c.oid = a.attrelid) AND (a.attnum = s.staattnum)))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((NOT a.attisdropped) AND has_column_privilege(c.oid, a.attnum, 'select'::text) AND ((c.relrowsecurity = false) OR (NOT row_security_active(c.oid)))); -pg_stats_ext| SELECT n.nspname AS schemaname, - c.relname AS tablename, - s.staname, - s.stakeys AS attnums, - length((s.standistinct)::bytea) AS ndistbytes, - length((s.stadependencies)::bytea) AS depsbytes - FROM ((pg_statistic_ext s - JOIN pg_class c ON ((c.oid = s.starelid))) - LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))); pg_tables| SELECT n.nspname AS schemaname, c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, |