From 3702633a4d89f38ca482ee884b2b117871a8da31 Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Thu, 7 Aug 2014 19:22:40 +0900 Subject: [PATCH] Remove unnecessary 'OR REPLACE' from sql function definitions. --- ext_scripts/pg_dbms_stats--1.3.3-9.1.sql | 6 ++---- ext_scripts/pg_dbms_stats--1.3.3-9.2.sql | 4 ++-- ext_scripts/pg_dbms_stats--1.3.3-9.3.sql | 6 ++---- 3 files changed, 6 insertions(+), 10 deletions(-) diff --git a/ext_scripts/pg_dbms_stats--1.3.3-9.1.sql b/ext_scripts/pg_dbms_stats--1.3.3-9.1.sql index d0e5369..ac9d200 100644 --- a/ext_scripts/pg_dbms_stats--1.3.3-9.1.sql +++ b/ext_scripts/pg_dbms_stats--1.3.3-9.1.sql @@ -1368,8 +1368,7 @@ LANGUAGE sql; -- -- PURGE_STATS: Statistic purge function -- - -CREATE OR REPLACE FUNCTION dbms_stats.purge_stats( +CREATE FUNCTION dbms_stats.purge_stats( backup_id int8, force bool DEFAULT false ) RETURNS SETOF dbms_stats.backup_history AS @@ -1417,8 +1416,7 @@ LANGUAGE plpgsql; -- -- CLEAN_STATS: Clean orphan dummy statistic -- - -CREATE OR REPLACE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS +CREATE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS $$ DECLARE clean_relid Oid; diff --git a/ext_scripts/pg_dbms_stats--1.3.3-9.2.sql b/ext_scripts/pg_dbms_stats--1.3.3-9.2.sql index 4079fb6..af14464 100644 --- a/ext_scripts/pg_dbms_stats--1.3.3-9.2.sql +++ b/ext_scripts/pg_dbms_stats--1.3.3-9.2.sql @@ -1426,7 +1426,7 @@ LANGUAGE sql; -- PURGE_STATS: Statistic purge function -- -CREATE OR REPLACE FUNCTION dbms_stats.purge_stats( +CREATE FUNCTION dbms_stats.purge_stats( backup_id int8, force bool DEFAULT false ) RETURNS SETOF dbms_stats.backup_history AS @@ -1475,7 +1475,7 @@ LANGUAGE plpgsql; -- CLEAN_STATS: Clean orphan dummy statistic -- -CREATE OR REPLACE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS +CREATE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS $$ DECLARE clean_relid Oid; diff --git a/ext_scripts/pg_dbms_stats--1.3.3-9.3.sql b/ext_scripts/pg_dbms_stats--1.3.3-9.3.sql index 650f482..a3bcc67 100644 --- a/ext_scripts/pg_dbms_stats--1.3.3-9.3.sql +++ b/ext_scripts/pg_dbms_stats--1.3.3-9.3.sql @@ -1425,8 +1425,7 @@ LANGUAGE sql; -- -- PURGE_STATS: Statistic purge function -- - -CREATE OR REPLACE FUNCTION dbms_stats.purge_stats( +CREATE FUNCTION dbms_stats.purge_stats( backup_id int8, force bool DEFAULT false ) RETURNS SETOF dbms_stats.backup_history AS @@ -1474,8 +1473,7 @@ LANGUAGE plpgsql; -- -- CLEAN_STATS: Clean orphan dummy statistic -- - -CREATE OR REPLACE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS +CREATE FUNCTION dbms_stats.clean_up_stats() RETURNS SETOF text AS $$ DECLARE clean_relid Oid; -- 2.11.0