Created
November 2, 2022 11:55
-
-
Save anozimada/50504768acbc548f5a15cb1d4aabe069 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* iDempiere NOTE: | |
Use this script to enable uuid generation JUST on postgresql versions prior to 9.1 | |
For Postgresql 9.1, run the CREATE EXTENSION "uuid-ossp" sql command instead of using this script | |
*/ | |
/* $PostgreSQL: pgsql/contrib/uuid-ossp/uuid-ossp.sql.in,v 1.6 2007/11/13 04:24:29 momjian Exp $ */ | |
-- Adjust this setting to control where the objects get created. | |
SET search_path = adempiere; | |
CREATE OR REPLACE FUNCTION uuid_nil() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_nil' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_ns_dns() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_ns_dns' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_ns_url() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_ns_url' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_ns_oid() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_ns_oid' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_ns_x500() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_ns_x500' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_generate_v1() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_generate_v1' | |
VOLATILE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_generate_v1mc() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_generate_v1mc' | |
VOLATILE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_generate_v3(namespace uuid, name text) | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_generate_v3' | |
IMMUTABLE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_generate_v4() | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_generate_v4' | |
VOLATILE STRICT LANGUAGE C; | |
CREATE OR REPLACE FUNCTION uuid_generate_v5(namespace uuid, name text) | |
RETURNS uuid | |
AS '$libdir/uuid-ossp', 'uuid_generate_v5' | |
IMMUTABLE STRICT LANGUAGE C; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment