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

Commit7e81a18

Browse files
committed
Fix parallel-safety markings for contrib/dblink.
As shown by buildfarm reports, dblink_build_sql_insert anddblink_build_sql_update are *not* parallel safe, because theymay attempt to access temporary tables of the local session.Although dblink_build_sql_delete doesn't actually touch thecontents of the referenced table, it seems consistent and prudentto mark it PARALLEL RESTRICTED too.
1 parent915b703 commit7e81a18

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

‎contrib/dblink/dblink--1.1--1.2.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -30,9 +30,9 @@ ALTER FUNCTION dblink_exec(text, text, boolean) PARALLEL RESTRICTED;
3030
ALTERFUNCTION dblink_exec(text) PARALLEL RESTRICTED;
3131
ALTERFUNCTION dblink_exec(text,boolean) PARALLEL RESTRICTED;
3232
ALTERFUNCTION dblink_get_pkey(text) PARALLEL RESTRICTED;
33-
ALTERFUNCTION dblink_build_sql_insert(text, int2vector,int, _text, _text) PARALLELSAFE;
34-
ALTERFUNCTION dblink_build_sql_delete(text, int2vector,int, _text) PARALLELSAFE;
35-
ALTERFUNCTION dblink_build_sql_update(text, int2vector,int, _text, _text) PARALLELSAFE;
33+
ALTERFUNCTION dblink_build_sql_insert(text, int2vector,int, _text, _text) PARALLELRESTRICTED;
34+
ALTERFUNCTION dblink_build_sql_delete(text, int2vector,int, _text) PARALLELRESTRICTED;
35+
ALTERFUNCTION dblink_build_sql_update(text, int2vector,int, _text, _text) PARALLELRESTRICTED;
3636
ALTERFUNCTION dblink_current_query() PARALLEL RESTRICTED;
3737
ALTERFUNCTION dblink_send_query(text,text) PARALLEL RESTRICTED;
3838
ALTERFUNCTION dblink_is_busy(text) PARALLEL RESTRICTED;

‎contrib/dblink/dblink--1.2.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -151,17 +151,17 @@ LANGUAGE C STRICT PARALLEL RESTRICTED;
151151
CREATEFUNCTIONdblink_build_sql_insert (text, int2vector,int, _text, _text)
152152
RETURNStext
153153
AS'MODULE_PATHNAME','dblink_build_sql_insert'
154-
LANGUAGE C STRICT PARALLELSAFE;
154+
LANGUAGE C STRICT PARALLELRESTRICTED;
155155

156156
CREATEFUNCTIONdblink_build_sql_delete (text, int2vector,int, _text)
157157
RETURNStext
158158
AS'MODULE_PATHNAME','dblink_build_sql_delete'
159-
LANGUAGE C STRICT PARALLELSAFE;
159+
LANGUAGE C STRICT PARALLELRESTRICTED;
160160

161161
CREATEFUNCTIONdblink_build_sql_update (text, int2vector,int, _text, _text)
162162
RETURNStext
163163
AS'MODULE_PATHNAME','dblink_build_sql_update'
164-
LANGUAGE C STRICT PARALLELSAFE;
164+
LANGUAGE C STRICT PARALLELRESTRICTED;
165165

166166
CREATEFUNCTIONdblink_current_query ()
167167
RETURNStext

0 commit comments

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