Hi hackers, I just noticed that all indents in upgrade scripts of pg_stat_statemets are made using spaces, except for "CREATE FUNCTION pg_stat_statements_reset" statement in pg_stat_statements--1.6--1.7.sql and pg_stat_statements--1.10--1.11.sql.
I made a patch to fix it in pg_stat_statements--1.10--1.11.sql if it's not too late for PostgreSQL 17 yet. Best regards, Karina Litskevich Postgres Professional: http://postgrespro.com/
From 2273e72e35fe2d4ff500a2127413121b1709be17 Mon Sep 17 00:00:00 2001 From: Karina Litskevich <litskevichkar...@gmail.com> Date: Mon, 23 Sep 2024 16:06:25 +0300 Subject: [PATCH v1] pg_stat_statements: use spaces to indent in upgrade scripts --- .../pg_stat_statements/pg_stat_statements--1.10--1.11.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/contrib/pg_stat_statements/pg_stat_statements--1.10--1.11.sql b/contrib/pg_stat_statements/pg_stat_statements--1.10--1.11.sql index 0bb2c39771..86769184a3 100644 --- a/contrib/pg_stat_statements/pg_stat_statements--1.10--1.11.sql +++ b/contrib/pg_stat_statements/pg_stat_statements--1.10--1.11.sql @@ -70,9 +70,9 @@ CREATE VIEW pg_stat_statements AS GRANT SELECT ON pg_stat_statements TO PUBLIC; CREATE FUNCTION pg_stat_statements_reset(IN userid Oid DEFAULT 0, - IN dbid Oid DEFAULT 0, - IN queryid bigint DEFAULT 0, - IN minmax_only boolean DEFAULT false + IN dbid Oid DEFAULT 0, + IN queryid bigint DEFAULT 0, + IN minmax_only boolean DEFAULT false ) RETURNS timestamp with time zone AS 'MODULE_PATHNAME', 'pg_stat_statements_reset_1_11' -- 2.34.1
