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

Commit13e7453

Browse files
committed
Update xml2 extension for parallel query.
All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson
1 parent20f6c3a commit13e7453

File tree

4 files changed

+34
-16
lines changed

4 files changed

+34
-16
lines changed

‎contrib/xml2/Makefile

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

66
EXTENSION = xml2
7-
DATA = xml2--1.0.sql xml2--unpackaged--1.0.sql
7+
DATA = xml2--1.1.sql xml2--1.0--1.1.sql xml2--unpackaged--1.0.sql
88
PGFILEDESC = "xml2 - XPath querying and XSLT"
99

1010
REGRESS = xml2

‎contrib/xml2/xml2--1.0--1.1.sql

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,18 @@
1+
/* contrib/xml2/xml2--1.0--1.1.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION xml2 UPDATE TO '1.1'" to load this file. \quit
5+
6+
ALTERFUNCTION xml_valid(text) PARALLEL SAFE;
7+
ALTERFUNCTION xml_encode_special_chars(text) PARALLEL SAFE;
8+
ALTERFUNCTION xpath_string(text,text) PARALLEL SAFE;
9+
ALTERFUNCTION xpath_nodeset(text,text,text,text) PARALLEL SAFE;
10+
ALTERFUNCTION xpath_number(text,text) PARALLEL SAFE;
11+
ALTERFUNCTION xpath_bool(text,text) PARALLEL SAFE;
12+
ALTERFUNCTION xpath_list(text,text,text) PARALLEL SAFE;
13+
ALTERFUNCTION xpath_list(text,text) PARALLEL SAFE;
14+
ALTERFUNCTION xpath_nodeset(text,text) PARALLEL SAFE;
15+
ALTERFUNCTION xpath_nodeset(text,text,text) PARALLEL SAFE;
16+
ALTERFUNCTION xpath_table(text,text,text,text,text) PARALLEL SAFE;
17+
ALTERFUNCTION xslt_process(text,text,text) PARALLEL SAFE;
18+
ALTERFUNCTION xslt_process(text,text) PARALLEL SAFE;
Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
/* contrib/xml2/xml2--1.0.sql*/
1+
/* contrib/xml2/xml2--1.1.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"CREATE EXTENSION xml2" to load this file. \quit
@@ -8,66 +8,66 @@
88
-- deprecated old name for xml_is_well_formed
99
CREATEFUNCTIONxml_valid(text) RETURNS bool
1010
AS'xml_is_well_formed'
11-
LANGUAGE INTERNAL STRICT STABLE;
11+
LANGUAGE INTERNAL STRICT STABLE PARALLEL SAFE;
1212

1313
CREATEFUNCTIONxml_encode_special_chars(text) RETURNStext
1414
AS'MODULE_PATHNAME'
15-
LANGUAGE C STRICT IMMUTABLE;
15+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
1616

1717
CREATEFUNCTIONxpath_string(text,text) RETURNStext
1818
AS'MODULE_PATHNAME'
19-
LANGUAGE C STRICT IMMUTABLE;
19+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
2020

2121
CREATEFUNCTIONxpath_nodeset(text,text,text,text) RETURNStext
2222
AS'MODULE_PATHNAME'
23-
LANGUAGE C STRICT IMMUTABLE;
23+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
2424

2525
CREATEFUNCTIONxpath_number(text,text) RETURNS float4
2626
AS'MODULE_PATHNAME'
27-
LANGUAGE C STRICT IMMUTABLE;
27+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
2828

2929
CREATEFUNCTIONxpath_bool(text,text) RETURNSboolean
3030
AS'MODULE_PATHNAME'
31-
LANGUAGE C STRICT IMMUTABLE;
31+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
3232

3333
-- List function
3434

3535
CREATEFUNCTIONxpath_list(text,text,text) RETURNStext
3636
AS'MODULE_PATHNAME'
37-
LANGUAGE C STRICT IMMUTABLE;
37+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
3838

3939
CREATEFUNCTIONxpath_list(text,text) RETURNStext
4040
AS'SELECT xpath_list($1,$2,'','')'
41-
LANGUAGE SQL STRICT IMMUTABLE;
41+
LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;
4242

4343
-- Wrapper functions for nodeset where no tags needed
4444

4545
CREATEFUNCTIONxpath_nodeset(text,text)
4646
RETURNStext
4747
AS'SELECT xpath_nodeset($1,$2,'''','''')'
48-
LANGUAGE SQL STRICT IMMUTABLE;
48+
LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;
4949

5050
CREATEFUNCTIONxpath_nodeset(text,text,text)
5151
RETURNStext
5252
AS'SELECT xpath_nodeset($1,$2,'''',$3)'
53-
LANGUAGE SQL STRICT IMMUTABLE;
53+
LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;
5454

5555
-- Table function
5656

5757
CREATEFUNCTIONxpath_table(text,text,text,text,text)
5858
RETURNS setof record
5959
AS'MODULE_PATHNAME'
60-
LANGUAGE C STRICT STABLE;
60+
LANGUAGE C STRICT STABLE PARALLEL SAFE;
6161

6262
-- XSLT functions
6363

6464
CREATEFUNCTIONxslt_process(text,text,text)
6565
RETURNStext
6666
AS'MODULE_PATHNAME'
67-
LANGUAGE C STRICT VOLATILE;
67+
LANGUAGE C STRICT VOLATILE PARALLEL SAFE;
6868

6969
-- the function checks for the correct argument count
7070
CREATEFUNCTIONxslt_process(text,text)
7171
RETURNStext
7272
AS'MODULE_PATHNAME'
73-
LANGUAGE C STRICT IMMUTABLE;
73+
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;

‎contrib/xml2/xml2.control

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
# xml2 extension
22
comment = 'XPath querying and XSLT'
3-
default_version = '1.0'
3+
default_version = '1.1'
44
module_pathname = '$libdir/pgxml'
55
# non-relocatable because xml2--unpackaged--1.0.sql needs to use @extschema@
66
relocatable = false

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp