diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-13 00:20:36 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-13 00:20:36 +0000 |
commit | 15fecdec5cc0d4a285aab63da5b4c3204e85b21b (patch) | |
tree | f19515717c96b433e0e406aa4344ff1c0bb7e958 | |
parent | 1ef648cfbc75041eddce48ef2e9eb004b7906efd (diff) | |
download | postgresql-15fecdec5cc0d4a285aab63da5b4c3204e85b21b.tar.gz postgresql-15fecdec5cc0d4a285aab63da5b4c3204e85b21b.zip |
Undo damage from yesterday's script "cleanup".
-rw-r--r-- | contrib/uuid-ossp/uuid-ossp.sql.in | 45 |
1 files changed, 23 insertions, 22 deletions
diff --git a/contrib/uuid-ossp/uuid-ossp.sql.in b/contrib/uuid-ossp/uuid-ossp.sql.in index abc8dfdebbe..93c8845ef14 100644 --- a/contrib/uuid-ossp/uuid-ossp.sql.in +++ b/contrib/uuid-ossp/uuid-ossp.sql.in @@ -1,53 +1,54 @@ --- Adjust this setting to control where the objects get dropped. +/* $PostgreSQL: pgsql/contrib/uuid-ossp/uuid-ossp.sql.in,v 1.4 2007/11/13 00:20:36 tgl Exp $ */ + +-- Adjust this setting to control where the objects get created. SET search_path = public; CREATE OR REPLACE FUNCTION uuid_nil() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_nil'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_nil' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_ns_dns() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_ns_dns'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_ns_dns' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_ns_url() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_ns_url'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_ns_url' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_ns_oid() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_ns_oid'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_ns_oid' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_ns_x500() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_ns_x500'; -IMMUTABLE STRICT LANGUAGE C - +AS 'MODULE_PATHNAME', 'uuid_ns_x500' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_generate_v1() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_generate_v1'; -VOLATILE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_generate_v1' +VOLATILE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_generate_v1mc() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_generate_v1mc'; -VOLATILE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_generate_v1mc' +VOLATILE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_generate_v3(namespace uuid, name text) RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_generate_v3'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_generate_v3' +IMMUTABLE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_generate_v4() RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_generate_v4'; -VOLATILE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_generate_v4' +VOLATILE STRICT LANGUAGE C; CREATE OR REPLACE FUNCTION uuid_generate_v5(namespace uuid, name text) RETURNS uuid -AS 'MODULE_PATHNAME', 'uuid_generate_v5'; -IMMUTABLE STRICT LANGUAGE C +AS 'MODULE_PATHNAME', 'uuid_generate_v5' +IMMUTABLE STRICT LANGUAGE C; |