Avoid use of CREATE OR REPLACE FUNCTION in extension installation files.

It was never terribly consistent to use OR REPLACE (because of the lack of
comparable functionality for data types, operators, etc), and
experimentation shows that it's now positively pernicious in the extension
world.  We really want a failure to occur if there are any conflicts, else
it's unclear what the extension-ownership state of the conflicted object
ought to be.  Most of the time, CREATE EXTENSION will fail anyway because
of conflicts on other object types, but an extension defining only
functions can succeed, with bad results.

1 files changed, 10 insertions, 10 deletions

diff --git a/contrib/uuid-ossp/uuid-ossp--1.0.sql b/contrib/uuid-ossp/uuid-ossp--1.0.sql
index 34b32de77e0..43ae0b38a0b 100644
--- a/contrib/uuid-ossp/uuid-ossp--1.0.sql
+++ b/contrib/uuid-ossp/uuid-ossp--1.0.sql
@@ -1,51 +1,51 @@
 /* contrib/uuid-ossp/uuid-ossp--1.0.sql */
 
-CREATE OR REPLACE FUNCTION uuid_nil()
+CREATE FUNCTION uuid_nil()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_nil'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_ns_dns()
+CREATE FUNCTION uuid_ns_dns()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_ns_dns'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_ns_url()
+CREATE FUNCTION uuid_ns_url()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_ns_url'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_ns_oid()
+CREATE FUNCTION uuid_ns_oid()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_ns_oid'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_ns_x500()
+CREATE FUNCTION uuid_ns_x500()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_ns_x500'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_generate_v1()
+CREATE FUNCTION uuid_generate_v1()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_generate_v1'
 VOLATILE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_generate_v1mc()
+CREATE FUNCTION uuid_generate_v1mc()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_generate_v1mc'
 VOLATILE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_generate_v3(namespace uuid, name text)
+CREATE FUNCTION uuid_generate_v3(namespace uuid, name text)
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_generate_v3'
 IMMUTABLE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_generate_v4()
+CREATE FUNCTION uuid_generate_v4()
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_generate_v4'
 VOLATILE STRICT LANGUAGE C;
 
-CREATE OR REPLACE FUNCTION uuid_generate_v5(namespace uuid, name text)
+CREATE FUNCTION uuid_generate_v5(namespace uuid, name text)
 RETURNS uuid
 AS 'MODULE_PATHNAME', 'uuid_generate_v5'
 IMMUTABLE STRICT LANGUAGE C;