1/* contrib/pg_stat_statements/pg_stat_statements--1.6--1.7.sql */
2
3-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4\echo Use "ALTER EXTENSION pg_stat_statements UPDATE TO '1.7'" to load this file. \quit
5
6/* First we have to remove them from the extension */
7ALTER EXTENSION pg_stat_statements DROP FUNCTION pg_stat_statements_reset();
8
9/* Then we can drop them */
10DROP FUNCTION pg_stat_statements_reset();
11
12/* Now redefine */
13CREATE FUNCTION pg_stat_statements_reset(IN userid Oid DEFAULT 0,
14	IN dbid Oid DEFAULT 0,
15	IN queryid bigint DEFAULT 0
16)
17RETURNS void
18AS 'MODULE_PATHNAME', 'pg_stat_statements_reset_1_7'
19LANGUAGE C STRICT PARALLEL SAFE;
20
21-- Don't want this to be available to non-superusers.
22REVOKE ALL ON FUNCTION pg_stat_statements_reset(Oid, Oid, bigint) FROM PUBLIC;
23