Remove unnecessary 'OR REPLACE' from sql function definitions.

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 (file)
--- 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 (file)
--- 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 (file)
--- 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;