NotificationsYou must be signed in to change notification settings
Fork28
Star153

Commit86897f5

Neil Conway

committed

This patch updates the DDL for contrib/pgcrypto to create all

functions as STRICT, and all functions except gen_salt() as IMMUTABLE.gen_salt() is VOLATILE.Although the functions are now STRICT, I left their PG_ARGISNULL()checks in place as a protective measure for users who install thenew code but use old (non-STRICT) catalog entries (e.g., restoredfrom a dump). Per recent discussion in pgsql-hackers.Patch from Michael Fuhr.

1 parent40ffa1a commit86897f5Copy full SHA for 86897f5

File tree

1 file changed

+14

-14

lines changed

contrib/pgcrypto
- pgcrypto.sql.in

1 file changed

+14

-14

lines changed

`‎contrib/pgcrypto/pgcrypto.sql.in‎`

Lines changed: 14 additions & 14 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,71 +4,71 @@ SET search_path = public;`
`4`	`4`	`CREATE OR REPLACE FUNCTION digest(text, text)`
`5`	`5`	`RETURNS bytea`
`6`	`6`	`AS 'MODULE_PATHNAME', 'pg_digest'`
`7`		`-LANGUAGE 'C';`
	`7`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`8`	`8`
`9`	`9`	`CREATE OR REPLACE FUNCTION digest(bytea, text)`
`10`	`10`	`RETURNS bytea`
`11`	`11`	`AS 'MODULE_PATHNAME', 'pg_digest'`
`12`		`-LANGUAGE 'C';`
	`12`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`13`	`13`
`14`	`14`	`CREATE OR REPLACE FUNCTION digest_exists(text)`
`15`	`15`	`RETURNS bool`
`16`	`16`	`AS 'MODULE_PATHNAME', 'pg_digest_exists'`
`17`		`-LANGUAGE 'C';`
	`17`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`18`	`18`
`19`	`19`	`CREATE OR REPLACE FUNCTION hmac(text, text, text)`
`20`	`20`	`RETURNS bytea`
`21`	`21`	`AS 'MODULE_PATHNAME', 'pg_hmac'`
`22`		`-LANGUAGE 'C';`
	`22`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`23`	`23`
`24`	`24`	`CREATE OR REPLACE FUNCTION hmac(bytea, bytea, text)`
`25`	`25`	`RETURNS bytea`
`26`	`26`	`AS 'MODULE_PATHNAME', 'pg_hmac'`
`27`		`-LANGUAGE 'C';`
	`27`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`28`	`28`
`29`	`29`	`CREATE OR REPLACE FUNCTION hmac_exists(text)`
`30`	`30`	`RETURNS bool`
`31`	`31`	`AS 'MODULE_PATHNAME', 'pg_hmac_exists'`
`32`		`-LANGUAGE 'C';`
	`32`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`33`	`33`
`34`	`34`	`CREATE OR REPLACE FUNCTION crypt(text, text)`
`35`	`35`	`RETURNS text`
`36`	`36`	`AS 'MODULE_PATHNAME', 'pg_crypt'`
`37`		`-LANGUAGE 'C';`
	`37`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`38`	`38`
`39`	`39`	`CREATE OR REPLACE FUNCTION gen_salt(text)`
`40`	`40`	`RETURNS text`
`41`	`41`	`AS 'MODULE_PATHNAME', 'pg_gen_salt'`
`42`		`-LANGUAGE 'C';`
	`42`	`+LANGUAGE 'C' VOLATILE STRICT;`
`43`	`43`
`44`	`44`	`CREATE OR REPLACE FUNCTION gen_salt(text, int4)`
`45`	`45`	`RETURNS text`
`46`	`46`	`AS 'MODULE_PATHNAME', 'pg_gen_salt_rounds'`
`47`		`-LANGUAGE 'C';`
	`47`	`+LANGUAGE 'C' VOLATILE STRICT;`
`48`	`48`
`49`	`49`	`CREATE OR REPLACE FUNCTION encrypt(bytea, bytea, text)`
`50`	`50`	`RETURNS bytea`
`51`	`51`	`AS 'MODULE_PATHNAME', 'pg_encrypt'`
`52`		`-LANGUAGE 'C';`
	`52`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`53`	`53`
`54`	`54`	`CREATE OR REPLACE FUNCTION decrypt(bytea, bytea, text)`
`55`	`55`	`RETURNS bytea`
`56`	`56`	`AS 'MODULE_PATHNAME', 'pg_decrypt'`
`57`		`-LANGUAGE 'C';`
	`57`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`58`	`58`
`59`	`59`	`CREATE OR REPLACE FUNCTION encrypt_iv(bytea, bytea, bytea, text)`
`60`	`60`	`RETURNS bytea`
`61`	`61`	`AS 'MODULE_PATHNAME', 'pg_encrypt_iv'`
`62`		`-LANGUAGE 'C';`
	`62`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`63`	`63`
`64`	`64`	`CREATE OR REPLACE FUNCTION decrypt_iv(bytea, bytea, bytea, text)`
`65`	`65`	`RETURNS bytea`
`66`	`66`	`AS 'MODULE_PATHNAME', 'pg_decrypt_iv'`
`67`		`-LANGUAGE 'C';`
	`67`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`68`	`68`
`69`	`69`	`CREATE OR REPLACE FUNCTION cipher_exists(text)`
`70`	`70`	`RETURNS bool`
`71`	`71`	`AS 'MODULE_PATHNAME', 'pg_cipher_exists'`
`72`		`-LANGUAGE 'C';`
	`72`	`+LANGUAGE 'C' IMMUTABLE STRICT;`
`73`	`73`
`74`	`74`

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!

Commit86897f5

File tree

1 file changed

1 file changed

`‎contrib/pgcrypto/pgcrypto.sql.in‎`

0 commit comments