aboutsummaryrefslogtreecommitdiff
path: root/contrib/pg_stat_statements
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-08-28 14:33:56 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2012-08-28 14:33:56 -0400
commit0a83f2492f38fd0b82452dfd2a80cc70486ba73d (patch)
tree1b9a363e66fe8e5e5e5448f9b81d94090194fd75 /contrib/pg_stat_statements
parent9db098dfa91906cee4fffc1e3ba8ba3899820d5f (diff)
downloadpostgresql-0a83f2492f38fd0b82452dfd2a80cc70486ba73d.tar.gz
postgresql-0a83f2492f38fd0b82452dfd2a80cc70486ba73d.zip
Remove pg_stat_statements--1.0.sql, too.
Per Peter Geoghegan.
Diffstat (limited to 'contrib/pg_stat_statements')
-rw-r--r--contrib/pg_stat_statements/pg_stat_statements--1.0.sql39
1 files changed, 0 insertions, 39 deletions
diff --git a/contrib/pg_stat_statements/pg_stat_statements--1.0.sql b/contrib/pg_stat_statements/pg_stat_statements--1.0.sql
deleted file mode 100644
index 5294a01dd52..00000000000
--- a/contrib/pg_stat_statements/pg_stat_statements--1.0.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-/* contrib/pg_stat_statements/pg_stat_statements--1.0.sql */
-
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
-\echo Use "CREATE EXTENSION pg_stat_statements" to load this file. \quit
-
--- Register functions.
-CREATE FUNCTION pg_stat_statements_reset()
-RETURNS void
-AS 'MODULE_PATHNAME'
-LANGUAGE C;
-
-CREATE FUNCTION pg_stat_statements(
- OUT userid oid,
- OUT dbid oid,
- OUT query text,
- OUT calls int8,
- OUT total_time float8,
- OUT rows int8,
- OUT shared_blks_hit int8,
- OUT shared_blks_read int8,
- OUT shared_blks_written int8,
- OUT local_blks_hit int8,
- OUT local_blks_read int8,
- OUT local_blks_written int8,
- OUT temp_blks_read int8,
- OUT temp_blks_written int8
-)
-RETURNS SETOF record
-AS 'MODULE_PATHNAME'
-LANGUAGE C;
-
--- Register a view on the function for ease of use.
-CREATE VIEW pg_stat_statements AS
- SELECT * FROM pg_stat_statements();
-
-GRANT SELECT ON pg_stat_statements TO PUBLIC;
-
--- Don't want this to be available to non-superusers.
-REVOKE ALL ON FUNCTION pg_stat_statements_reset() FROM PUBLIC;