NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit0dbf3ce

committed

Update pgcrypto extension for parallel query.

All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson

1 parent06d7fd6 commit0dbf3ceCopy full SHA for 0dbf3ce

File tree

4 files changed

+80

-39

lines changed

contrib/pgcrypto

4 files changed

+80

-39

lines changed

`‎contrib/pgcrypto/Makefile`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -26,8 +26,8 @@ MODULE_big= pgcrypto`
`26`	`26`	`OBJS=$(SRCS:.c=.o)$(WIN32RES)`
`27`	`27`
`28`	`28`	`EXTENSION = pgcrypto`
`29`		`-DATA = pgcrypto--1.2.sql pgcrypto--1.1--1.2.sql pgcrypto--1.0--1.1.sql\`
`30`		`-pgcrypto--unpackaged--1.0.sql`
	`29`	`+DATA = pgcrypto--1.3.sql pgcrypto--1.2--1.3.sql pgcrypto--1.1--1.2.sql\`
	`30`	`+pgcrypto--1.0--1.1.sql pgcrypto--unpackaged--1.0.sql`
`31`	`31`	`PGFILEDESC = "pgcrypto - cryptographic functions"`
`32`	`32`
`33`	`33`	`REGRESS = init md5 sha1 hmac-md5 hmac-sha1 blowfish rijndael\`

`‎contrib/pgcrypto/pgcrypto--1.2--1.3.sql`

Lines changed: 41 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,41 @@`
	`1`	`+/* contrib/pgcrypto/pgcrypto--1.2--1.3.sql*/`
	`2`	`+`
	`3`	`+-- complain if script is sourced in psql, rather than via ALTER EXTENSION`
	`4`	`+\echo Use"ALTER EXTENSION pgcrypto UPDATE TO '1.3'" to load this file. \quit`
	`5`	`+`
	`6`	`+ALTERFUNCTION digest(text,text) PARALLEL SAFE;`
	`7`	`+ALTERFUNCTION digest(bytea,text) PARALLEL SAFE;`
	`8`	`+ALTERFUNCTION hmac(text,text,text) PARALLEL SAFE;`
	`9`	`+ALTERFUNCTION hmac(bytea,bytea,text) PARALLEL SAFE;`
	`10`	`+ALTERFUNCTION crypt(text,text) PARALLEL SAFE;`
	`11`	`+ALTERFUNCTION gen_salt(text) PARALLEL SAFE;`
	`12`	`+ALTERFUNCTION gen_salt(text, int4) PARALLEL SAFE;`
	`13`	`+ALTERFUNCTION encrypt(bytea,bytea,text) PARALLEL SAFE;`
	`14`	`+ALTERFUNCTION decrypt(bytea,bytea,text) PARALLEL SAFE;`
	`15`	`+ALTERFUNCTION encrypt_iv(bytea,bytea,bytea,text) PARALLEL SAFE;`
	`16`	`+ALTERFUNCTION decrypt_iv(bytea,bytea,bytea,text) PARALLEL SAFE;`
	`17`	`+ALTERFUNCTION gen_random_bytes(int4) PARALLEL SAFE;`
	`18`	`+ALTERFUNCTION gen_random_uuid() PARALLEL SAFE;`
	`19`	`+ALTERFUNCTION pgp_sym_encrypt(text,text) PARALLEL SAFE;`
	`20`	`+ALTERFUNCTION pgp_sym_encrypt_bytea(bytea,text) PARALLEL SAFE;`
	`21`	`+ALTERFUNCTION pgp_sym_encrypt(text,text,text) PARALLEL SAFE;`
	`22`	`+ALTERFUNCTION pgp_sym_encrypt_bytea(bytea,text,text) PARALLEL SAFE;`
	`23`	`+ALTERFUNCTION pgp_sym_decrypt(bytea,text) PARALLEL SAFE;`
	`24`	`+ALTERFUNCTION pgp_sym_decrypt_bytea(bytea,text) PARALLEL SAFE;`
	`25`	`+ALTERFUNCTION pgp_sym_decrypt(bytea,text,text) PARALLEL SAFE;`
	`26`	`+ALTERFUNCTION pgp_sym_decrypt_bytea(bytea,text,text) PARALLEL SAFE;`
	`27`	`+ALTERFUNCTION pgp_pub_encrypt(text,bytea) PARALLEL SAFE;`
	`28`	`+ALTERFUNCTION pgp_pub_encrypt_bytea(bytea,bytea) PARALLEL SAFE;`
	`29`	`+ALTERFUNCTION pgp_pub_encrypt(text,bytea,text) PARALLEL SAFE;`
	`30`	`+ALTERFUNCTION pgp_pub_encrypt_bytea(bytea,bytea,text) PARALLEL SAFE;`
	`31`	`+ALTERFUNCTION pgp_pub_decrypt(bytea,bytea) PARALLEL SAFE;`
	`32`	`+ALTERFUNCTION pgp_pub_decrypt_bytea(bytea,bytea) PARALLEL SAFE;`
	`33`	`+ALTERFUNCTION pgp_pub_decrypt(bytea,bytea,text) PARALLEL SAFE;`
	`34`	`+ALTERFUNCTION pgp_pub_decrypt_bytea(bytea,bytea,text) PARALLEL SAFE;`
	`35`	`+ALTERFUNCTION pgp_pub_decrypt(bytea,bytea,text,text) PARALLEL SAFE;`
	`36`	`+ALTERFUNCTION pgp_pub_decrypt_bytea(bytea,bytea,text,text) PARALLEL SAFE;`
	`37`	`+ALTERFUNCTION pgp_key_id(bytea) PARALLEL SAFE;`
	`38`	`+ALTERFUNCTION armor(bytea) PARALLEL SAFE;`
	`39`	`+ALTERFUNCTION armor(bytea,text[],text[]) PARALLEL SAFE;`
	`40`	`+ALTERFUNCTION dearmor(text) PARALLEL SAFE;`
	`41`	`+ALTERFUNCTION pgp_armor_headers(text) PARALLEL SAFE;`

`‎contrib/pgcrypto/pgcrypto--1.2.sqlrenamed to‎contrib/pgcrypto/pgcrypto--1.3.sql`

Lines changed: 36 additions & 36 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,212 +6,212 @@`
`6`	`6`	`CREATEFUNCTIONdigest(text,text)`
`7`	`7`	`RETURNSbytea`
`8`	`8`	`AS'MODULE_PATHNAME','pg_digest'`
`9`		`-LANGUAGE C IMMUTABLE STRICT;`
	`9`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`10`	`10`
`11`	`11`	`CREATEFUNCTIONdigest(bytea,text)`
`12`	`12`	`RETURNSbytea`
`13`	`13`	`AS'MODULE_PATHNAME','pg_digest'`
`14`		`-LANGUAGE C IMMUTABLE STRICT;`
	`14`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`15`	`15`
`16`	`16`	`CREATEFUNCTIONhmac(text,text,text)`
`17`	`17`	`RETURNSbytea`
`18`	`18`	`AS'MODULE_PATHNAME','pg_hmac'`
`19`		`-LANGUAGE C IMMUTABLE STRICT;`
	`19`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`20`	`20`
`21`	`21`	`CREATEFUNCTIONhmac(bytea,bytea,text)`
`22`	`22`	`RETURNSbytea`
`23`	`23`	`AS'MODULE_PATHNAME','pg_hmac'`
`24`		`-LANGUAGE C IMMUTABLE STRICT;`
	`24`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`25`	`25`
`26`	`26`	`CREATEFUNCTIONcrypt(text,text)`
`27`	`27`	`RETURNStext`
`28`	`28`	`AS'MODULE_PATHNAME','pg_crypt'`
`29`		`-LANGUAGE C IMMUTABLE STRICT;`
	`29`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`30`	`30`
`31`	`31`	`CREATEFUNCTIONgen_salt(text)`
`32`	`32`	`RETURNStext`
`33`	`33`	`AS'MODULE_PATHNAME','pg_gen_salt'`
`34`		`-LANGUAGE C VOLATILE STRICT;`
	`34`	`+LANGUAGE C VOLATILE STRICT PARALLEL SAFE;`
`35`	`35`
`36`	`36`	`CREATEFUNCTIONgen_salt(text, int4)`
`37`	`37`	`RETURNStext`
`38`	`38`	`AS'MODULE_PATHNAME','pg_gen_salt_rounds'`
`39`		`-LANGUAGE C VOLATILE STRICT;`
	`39`	`+LANGUAGE C VOLATILE STRICT PARALLEL SAFE;`
`40`	`40`
`41`	`41`	`CREATEFUNCTIONencrypt(bytea,bytea,text)`
`42`	`42`	`RETURNSbytea`
`43`	`43`	`AS'MODULE_PATHNAME','pg_encrypt'`
`44`		`-LANGUAGE C IMMUTABLE STRICT;`
	`44`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`45`	`45`
`46`	`46`	`CREATEFUNCTIONdecrypt(bytea,bytea,text)`
`47`	`47`	`RETURNSbytea`
`48`	`48`	`AS'MODULE_PATHNAME','pg_decrypt'`
`49`		`-LANGUAGE C IMMUTABLE STRICT;`
	`49`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`50`	`50`
`51`	`51`	`CREATEFUNCTIONencrypt_iv(bytea,bytea,bytea,text)`
`52`	`52`	`RETURNSbytea`
`53`	`53`	`AS'MODULE_PATHNAME','pg_encrypt_iv'`
`54`		`-LANGUAGE C IMMUTABLE STRICT;`
	`54`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`55`	`55`
`56`	`56`	`CREATEFUNCTIONdecrypt_iv(bytea,bytea,bytea,text)`
`57`	`57`	`RETURNSbytea`
`58`	`58`	`AS'MODULE_PATHNAME','pg_decrypt_iv'`
`59`		`-LANGUAGE C IMMUTABLE STRICT;`
	`59`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`60`	`60`
`61`	`61`	`CREATEFUNCTIONgen_random_bytes(int4)`
`62`	`62`	`RETURNSbytea`
`63`	`63`	`AS'MODULE_PATHNAME','pg_random_bytes'`
`64`		`-LANGUAGE C VOLATILE STRICT;`
	`64`	`+LANGUAGE C VOLATILE STRICT PARALLEL SAFE;`
`65`	`65`
`66`	`66`	`CREATEFUNCTIONgen_random_uuid()`
`67`	`67`	`RETURNS uuid`
`68`	`68`	`AS'MODULE_PATHNAME','pg_random_uuid'`
`69`		`-LANGUAGE C VOLATILE;`
	`69`	`+LANGUAGE C VOLATILE PARALLEL SAFE;`
`70`	`70`
`71`	`71`	`--`
`72`	`72`	`-- pgp_sym_encrypt(data, key)`
`73`	`73`	`--`
`74`	`74`	`CREATEFUNCTIONpgp_sym_encrypt(text,text)`
`75`	`75`	`RETURNSbytea`
`76`	`76`	`AS'MODULE_PATHNAME','pgp_sym_encrypt_text'`
`77`		`-LANGUAGE C STRICT;`
	`77`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`78`	`78`
`79`	`79`	`CREATEFUNCTIONpgp_sym_encrypt_bytea(bytea,text)`
`80`	`80`	`RETURNSbytea`
`81`	`81`	`AS'MODULE_PATHNAME','pgp_sym_encrypt_bytea'`
`82`		`-LANGUAGE C STRICT;`
	`82`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`83`	`83`
`84`	`84`	`--`
`85`	`85`	`-- pgp_sym_encrypt(data, key, args)`
`86`	`86`	`--`
`87`	`87`	`CREATEFUNCTIONpgp_sym_encrypt(text,text,text)`
`88`	`88`	`RETURNSbytea`
`89`	`89`	`AS'MODULE_PATHNAME','pgp_sym_encrypt_text'`
`90`		`-LANGUAGE C STRICT;`
	`90`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`91`	`91`
`92`	`92`	`CREATEFUNCTIONpgp_sym_encrypt_bytea(bytea,text,text)`
`93`	`93`	`RETURNSbytea`
`94`	`94`	`AS'MODULE_PATHNAME','pgp_sym_encrypt_bytea'`
`95`		`-LANGUAGE C STRICT;`
	`95`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`96`	`96`
`97`	`97`	`--`
`98`	`98`	`-- pgp_sym_decrypt(data, key)`
`99`	`99`	`--`
`100`	`100`	`CREATEFUNCTIONpgp_sym_decrypt(bytea,text)`
`101`	`101`	`RETURNStext`
`102`	`102`	`AS'MODULE_PATHNAME','pgp_sym_decrypt_text'`
`103`		`-LANGUAGE C IMMUTABLE STRICT;`
	`103`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`104`	`104`
`105`	`105`	`CREATEFUNCTIONpgp_sym_decrypt_bytea(bytea,text)`
`106`	`106`	`RETURNSbytea`
`107`	`107`	`AS'MODULE_PATHNAME','pgp_sym_decrypt_bytea'`
`108`		`-LANGUAGE C IMMUTABLE STRICT;`
	`108`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`109`	`109`
`110`	`110`	`--`
`111`	`111`	`-- pgp_sym_decrypt(data, key, args)`
`112`	`112`	`--`
`113`	`113`	`CREATEFUNCTIONpgp_sym_decrypt(bytea,text,text)`
`114`	`114`	`RETURNStext`
`115`	`115`	`AS'MODULE_PATHNAME','pgp_sym_decrypt_text'`
`116`		`-LANGUAGE C IMMUTABLE STRICT;`
	`116`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`117`	`117`
`118`	`118`	`CREATEFUNCTIONpgp_sym_decrypt_bytea(bytea,text,text)`
`119`	`119`	`RETURNSbytea`
`120`	`120`	`AS'MODULE_PATHNAME','pgp_sym_decrypt_bytea'`
`121`		`-LANGUAGE C IMMUTABLE STRICT;`
	`121`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`122`	`122`
`123`	`123`	`--`
`124`	`124`	`-- pgp_pub_encrypt(data, key)`
`125`	`125`	`--`
`126`	`126`	`CREATEFUNCTIONpgp_pub_encrypt(text,bytea)`
`127`	`127`	`RETURNSbytea`
`128`	`128`	`AS'MODULE_PATHNAME','pgp_pub_encrypt_text'`
`129`		`-LANGUAGE C STRICT;`
	`129`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`130`	`130`
`131`	`131`	`CREATEFUNCTIONpgp_pub_encrypt_bytea(bytea,bytea)`
`132`	`132`	`RETURNSbytea`
`133`	`133`	`AS'MODULE_PATHNAME','pgp_pub_encrypt_bytea'`
`134`		`-LANGUAGE C STRICT;`
	`134`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`135`	`135`
`136`	`136`	`--`
`137`	`137`	`-- pgp_pub_encrypt(data, key, args)`
`138`	`138`	`--`
`139`	`139`	`CREATEFUNCTIONpgp_pub_encrypt(text,bytea,text)`
`140`	`140`	`RETURNSbytea`
`141`	`141`	`AS'MODULE_PATHNAME','pgp_pub_encrypt_text'`
`142`		`-LANGUAGE C STRICT;`
	`142`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`143`	`143`
`144`	`144`	`CREATEFUNCTIONpgp_pub_encrypt_bytea(bytea,bytea,text)`
`145`	`145`	`RETURNSbytea`
`146`	`146`	`AS'MODULE_PATHNAME','pgp_pub_encrypt_bytea'`
`147`		`-LANGUAGE C STRICT;`
	`147`	`+LANGUAGE C STRICT PARALLEL SAFE;`
`148`	`148`
`149`	`149`	`--`
`150`	`150`	`-- pgp_pub_decrypt(data, key)`
`151`	`151`	`--`
`152`	`152`	`CREATEFUNCTIONpgp_pub_decrypt(bytea,bytea)`
`153`	`153`	`RETURNStext`
`154`	`154`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_text'`
`155`		`-LANGUAGE C IMMUTABLE STRICT;`
	`155`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`156`	`156`
`157`	`157`	`CREATEFUNCTIONpgp_pub_decrypt_bytea(bytea,bytea)`
`158`	`158`	`RETURNSbytea`
`159`	`159`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_bytea'`
`160`		`-LANGUAGE C IMMUTABLE STRICT;`
	`160`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`161`	`161`
`162`	`162`	`--`
`163`	`163`	`-- pgp_pub_decrypt(data, key, psw)`
`164`	`164`	`--`
`165`	`165`	`CREATEFUNCTIONpgp_pub_decrypt(bytea,bytea,text)`
`166`	`166`	`RETURNStext`
`167`	`167`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_text'`
`168`		`-LANGUAGE C IMMUTABLE STRICT;`
	`168`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`169`	`169`
`170`	`170`	`CREATEFUNCTIONpgp_pub_decrypt_bytea(bytea,bytea,text)`
`171`	`171`	`RETURNSbytea`
`172`	`172`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_bytea'`
`173`		`-LANGUAGE C IMMUTABLE STRICT;`
	`173`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`174`	`174`
`175`	`175`	`--`
`176`	`176`	`-- pgp_pub_decrypt(data, key, psw, arg)`
`177`	`177`	`--`
`178`	`178`	`CREATEFUNCTIONpgp_pub_decrypt(bytea,bytea,text,text)`
`179`	`179`	`RETURNStext`
`180`	`180`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_text'`
`181`		`-LANGUAGE C IMMUTABLE STRICT;`
	`181`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`182`	`182`
`183`	`183`	`CREATEFUNCTIONpgp_pub_decrypt_bytea(bytea,bytea,text,text)`
`184`	`184`	`RETURNSbytea`
`185`	`185`	`AS'MODULE_PATHNAME','pgp_pub_decrypt_bytea'`
`186`		`-LANGUAGE C IMMUTABLE STRICT;`
	`186`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`187`	`187`
`188`	`188`	`--`
`189`	`189`	`-- PGP key ID`
`190`	`190`	`--`
`191`	`191`	`CREATEFUNCTIONpgp_key_id(bytea)`
`192`	`192`	`RETURNStext`
`193`	`193`	`AS'MODULE_PATHNAME','pgp_key_id_w'`
`194`		`-LANGUAGE C IMMUTABLE STRICT;`
	`194`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`195`	`195`
`196`	`196`	`--`
`197`	`197`	`-- pgp armor`
`198`	`198`	`--`
`199`	`199`	`CREATEFUNCTIONarmor(bytea)`
`200`	`200`	`RETURNStext`
`201`	`201`	`AS'MODULE_PATHNAME','pg_armor'`
`202`		`-LANGUAGE C IMMUTABLE STRICT;`
	`202`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`203`	`203`
`204`	`204`	`CREATEFUNCTIONarmor(bytea,text[],text[])`
`205`	`205`	`RETURNStext`
`206`	`206`	`AS'MODULE_PATHNAME','pg_armor'`
`207`		`-LANGUAGE C IMMUTABLE STRICT;`
	`207`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`208`	`208`
`209`	`209`	`CREATEFUNCTIONdearmor(text)`
`210`	`210`	`RETURNSbytea`
`211`	`211`	`AS'MODULE_PATHNAME','pg_dearmor'`
`212`		`-LANGUAGE C IMMUTABLE STRICT;`
	`212`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`
`213`	`213`
`214`	`214`	`CREATEFUNCTIONpgp_armor_headers(text, key OUTtext, value OUTtext)`
`215`	`215`	`RETURNS SETOF record`
`216`	`216`	`AS'MODULE_PATHNAME','pgp_armor_headers'`
`217`		`-LANGUAGE C IMMUTABLE STRICT;`
	`217`	`+LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;`

`‎contrib/pgcrypto/pgcrypto.control`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`# pgcrypto extension`
`2`	`2`	`comment = 'cryptographic functions'`
`3`		`-default_version = '1.2'`
	`3`	`+default_version = '1.3'`
`4`	`4`	`module_pathname = '$libdir/pgcrypto'`
`5`	`5`	`relocatable = true`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit0dbf3ce

File tree

4 files changed

4 files changed

`‎contrib/pgcrypto/Makefile`

`‎contrib/pgcrypto/pgcrypto--1.2--1.3.sql`

`‎contrib/pgcrypto/pgcrypto--1.2.sqlrenamed to‎contrib/pgcrypto/pgcrypto--1.3.sql`

`‎contrib/pgcrypto/pgcrypto.control`

0 commit comments