diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-08-28 14:33:56 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-08-28 14:33:56 -0400 |
commit | 0a83f2492f38fd0b82452dfd2a80cc70486ba73d (patch) | |
tree | 1b9a363e66fe8e5e5e5448f9b81d94090194fd75 /contrib/pg_stat_statements | |
parent | 9db098dfa91906cee4fffc1e3ba8ba3899820d5f (diff) | |
download | postgresql-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.sql | 39 |
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; |