diff options
Diffstat (limited to 'contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql')
| -rw-r--r-- | contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql b/contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql index fdd75e8a72..a4d50d3c4e 100644 --- a/contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql +++ b/contrib/pg_walinspect/pg_walinspect--1.0--1.1.sql @@ -12,6 +12,7 @@ DROP FUNCTION pg_get_wal_stats_till_end_of_wal(pg_lsn, boolean); -- CREATE FUNCTION pg_get_wal_block_info(IN start_lsn pg_lsn, IN end_lsn pg_lsn, + IN show_data boolean DEFAULT true, OUT start_lsn pg_lsn, OUT end_lsn pg_lsn, OUT prev_lsn pg_lsn, @@ -37,5 +38,5 @@ RETURNS SETOF record AS 'MODULE_PATHNAME', 'pg_get_wal_block_info' LANGUAGE C STRICT PARALLEL SAFE; -REVOKE EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn) FROM PUBLIC; -GRANT EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn) TO pg_read_server_files; +REVOKE EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) FROM PUBLIC; +GRANT EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) TO pg_read_server_files; |