Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit20f6c3a

Browse files
committed
Update uuid-ossp extension for parallel query.
All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson
1 parent202ac08 commit20f6c3a

File tree

4 files changed

+28
-13
lines changed

4 files changed

+28
-13
lines changed

‎contrib/uuid-ossp/Makefile

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ MODULE_big = uuid-ossp
44
OBJS = uuid-ossp.o$(UUID_EXTRA_OBJS)$(WIN32RES)
55

66
EXTENSION = uuid-ossp
7-
DATA = uuid-ossp--1.0.sql uuid-ossp--unpackaged--1.0.sql
7+
DATA = uuid-ossp--1.1.sql uuid-ossp--1.0--1.1.sql uuid-ossp--unpackaged--1.0.sql
88
PGFILEDESC = "uuid-ossp - UUID generation"
99

1010
REGRESS = uuid_ossp
Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
/* contrib/uuid-ossp/uuid-ossp--1.0--1.1.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION uuid-ossp UPDATE TO '1.1'" to load this file. \quit
5+
6+
ALTERFUNCTION uuid_nil() PARALLEL SAFE;
7+
ALTERFUNCTION uuid_ns_dns() PARALLEL SAFE;
8+
ALTERFUNCTION uuid_ns_url() PARALLEL SAFE;
9+
ALTERFUNCTION uuid_ns_oid() PARALLEL SAFE;
10+
ALTERFUNCTION uuid_ns_x500() PARALLEL SAFE;
11+
ALTERFUNCTION uuid_generate_v1() PARALLEL SAFE;
12+
ALTERFUNCTION uuid_generate_v1mc() PARALLEL SAFE;
13+
ALTERFUNCTION uuid_generate_v3(uuid,text) PARALLEL SAFE;
14+
ALTERFUNCTION uuid_generate_v4() PARALLEL SAFE;
15+
ALTERFUNCTION uuid_generate_v5(uuid,text) PARALLEL SAFE;
Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,54 +1,54 @@
1-
/* contrib/uuid-ossp/uuid-ossp--1.0.sql*/
1+
/* contrib/uuid-ossp/uuid-ossp--1.1.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use'''CREATE EXTENSION "uuid-ossp"''' to load this file. \quit
55

66
CREATEFUNCTIONuuid_nil()
77
RETURNS uuid
88
AS'MODULE_PATHNAME','uuid_nil'
9-
IMMUTABLE STRICT LANGUAGE C;
9+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
1010

1111
CREATEFUNCTIONuuid_ns_dns()
1212
RETURNS uuid
1313
AS'MODULE_PATHNAME','uuid_ns_dns'
14-
IMMUTABLE STRICT LANGUAGE C;
14+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
1515

1616
CREATEFUNCTIONuuid_ns_url()
1717
RETURNS uuid
1818
AS'MODULE_PATHNAME','uuid_ns_url'
19-
IMMUTABLE STRICT LANGUAGE C;
19+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
2020

2121
CREATEFUNCTIONuuid_ns_oid()
2222
RETURNS uuid
2323
AS'MODULE_PATHNAME','uuid_ns_oid'
24-
IMMUTABLE STRICT LANGUAGE C;
24+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
2525

2626
CREATEFUNCTIONuuid_ns_x500()
2727
RETURNS uuid
2828
AS'MODULE_PATHNAME','uuid_ns_x500'
29-
IMMUTABLE STRICT LANGUAGE C;
29+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
3030

3131
CREATEFUNCTIONuuid_generate_v1()
3232
RETURNS uuid
3333
AS'MODULE_PATHNAME','uuid_generate_v1'
34-
VOLATILE STRICT LANGUAGE C;
34+
VOLATILE STRICT LANGUAGE C PARALLEL SAFE;
3535

3636
CREATEFUNCTIONuuid_generate_v1mc()
3737
RETURNS uuid
3838
AS'MODULE_PATHNAME','uuid_generate_v1mc'
39-
VOLATILE STRICT LANGUAGE C;
39+
VOLATILE STRICT LANGUAGE C PARALLEL SAFE;
4040

4141
CREATEFUNCTIONuuid_generate_v3(namespace uuid, nametext)
4242
RETURNS uuid
4343
AS'MODULE_PATHNAME','uuid_generate_v3'
44-
IMMUTABLE STRICT LANGUAGE C;
44+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;
4545

4646
CREATEFUNCTIONuuid_generate_v4()
4747
RETURNS uuid
4848
AS'MODULE_PATHNAME','uuid_generate_v4'
49-
VOLATILE STRICT LANGUAGE C;
49+
VOLATILE STRICT LANGUAGE C PARALLEL SAFE;
5050

5151
CREATEFUNCTIONuuid_generate_v5(namespace uuid, nametext)
5252
RETURNS uuid
5353
AS'MODULE_PATHNAME','uuid_generate_v5'
54-
IMMUTABLE STRICT LANGUAGE C;
54+
IMMUTABLE STRICT LANGUAGE C PARALLEL SAFE;

‎contrib/uuid-ossp/uuid-ossp.control

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# uuid-ossp extension
22
comment = 'generate universally unique identifiers (UUIDs)'
3-
default_version = '1.0'
3+
default_version = '1.1'
44
module_pathname = '$libdir/uuid-ossp'
55
relocatable = true

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp