NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitf8203f9

committed

Support functions for index opclasses should be immutable.

Found by running opr_sanity on contrib modules.

1 parent60e83ce commitf8203f9Copy full SHA for f8203f9

File tree

2 files changed

+24

-24

lines changed

contrib
- pg_trgm
  - pg_trgm.sql.in
- seg
  - seg.sql.in

2 files changed

+24

-24

lines changed

`‎contrib/pg_trgm/pg_trgm.sql.in`

Lines changed: 17 additions & 17 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,27 +5,27 @@ BEGIN;`
`5`	`5`	`create function set_limit(float4)`
`6`	`6`	`returns float4`
`7`	`7`	`AS 'MODULE_PATHNAME'`
`8`		`-LANGUAGE CRETURNS NULL ON NULL INPUT IMMUTABLE;`
	`8`	`+LANGUAGE CSTRICT IMMUTABLE;`
`9`	`9`
`10`	`10`	`create function show_limit()`
`11`	`11`	`returns float4`
`12`	`12`	`AS 'MODULE_PATHNAME'`
`13`		`-LANGUAGE CRETURNS NULL ON NULL INPUT IMMUTABLE;`
	`13`	`+LANGUAGE CSTRICT IMMUTABLE;`
`14`	`14`
`15`	`15`	`create function show_trgm(text)`
`16`	`16`	`returns _text`
`17`	`17`	`AS 'MODULE_PATHNAME'`
`18`		`-LANGUAGE CRETURNS NULL ON NULL INPUT IMMUTABLE;`
	`18`	`+LANGUAGE CSTRICT IMMUTABLE;`
`19`	`19`
`20`	`20`	`create function similarity(text,text)`
`21`	`21`	`returns float4`
`22`	`22`	`AS 'MODULE_PATHNAME'`
`23`		`-LANGUAGE CRETURNS NULL ON NULL INPUT IMMUTABLE;`
	`23`	`+LANGUAGE CSTRICT IMMUTABLE;`
`24`	`24`
`25`	`25`	`create function similarity_op(text,text)`
`26`	`26`	`returns bool`
`27`	`27`	`AS 'MODULE_PATHNAME'`
`28`		`-LANGUAGE CRETURNS NULL ON NULL INPUT IMMUTABLE;`
	`28`	`+LANGUAGE CSTRICT IMMUTABLE;`
`29`	`29`
`30`	`30`	`CREATE OPERATOR % (`
`31`	`31`	`LEFTARG = text,`
`@@ -40,12 +40,12 @@ CREATE OPERATOR % (`
`40`	`40`	`CREATE FUNCTION gtrgm_in(cstring)`
`41`	`41`	`RETURNS gtrgm`
`42`	`42`	`AS 'MODULE_PATHNAME'`
`43`		`-LANGUAGE CRETURNS NULL ON NULL INPUT;`
	`43`	`+LANGUAGE CSTRICT;`
`44`	`44`
`45`	`45`	`CREATE FUNCTION gtrgm_out(gtrgm)`
`46`	`46`	`RETURNS cstring`
`47`	`47`	`AS 'MODULE_PATHNAME'`
`48`		`-LANGUAGE CRETURNS NULL ON NULL INPUT;`
	`48`	`+LANGUAGE CSTRICT;`
`49`	`49`
`50`	`50`	`CREATE TYPE gtrgm (`
`51`	`51`	`INTERNALLENGTH = -1,`
`@@ -57,37 +57,37 @@ CREATE TYPE gtrgm (`
`57`	`57`	`CREATE FUNCTION gtrgm_consistent(gtrgm,internal,int4)`
`58`	`58`	`RETURNS bool`
`59`	`59`	`AS 'MODULE_PATHNAME'`
`60`		`-LANGUAGE C;`
	`60`	`+LANGUAGE C IMMUTABLE;`
`61`	`61`
`62`	`62`	`CREATE FUNCTION gtrgm_compress(internal)`
`63`	`63`	`RETURNS internal`
`64`	`64`	`AS 'MODULE_PATHNAME'`
`65`		`-LANGUAGE C;`
	`65`	`+LANGUAGE C IMMUTABLE;`
`66`	`66`
`67`	`67`	`CREATE FUNCTION gtrgm_decompress(internal)`
`68`	`68`	`RETURNS internal`
`69`	`69`	`AS 'MODULE_PATHNAME'`
`70`		`-LANGUAGE C;`
	`70`	`+LANGUAGE C IMMUTABLE;`
`71`	`71`
`72`	`72`	`CREATE FUNCTION gtrgm_penalty(internal,internal,internal)`
`73`	`73`	`RETURNS internal`
`74`	`74`	`AS 'MODULE_PATHNAME'`
`75`		`-LANGUAGE CRETURNS NULL ON NULL INPUT;`
	`75`	`+LANGUAGE CSTRICT IMMUTABLE;`
`76`	`76`
`77`	`77`	`CREATE FUNCTION gtrgm_picksplit(internal, internal)`
`78`	`78`	`RETURNS internal`
`79`	`79`	`AS 'MODULE_PATHNAME'`
`80`		`-LANGUAGE C;`
	`80`	`+LANGUAGE C IMMUTABLE;`
`81`	`81`
`82`	`82`	`CREATE FUNCTION gtrgm_union(bytea, internal)`
`83`	`83`	`RETURNS _int4`
`84`	`84`	`AS 'MODULE_PATHNAME'`
`85`		`-LANGUAGE C;`
	`85`	`+LANGUAGE C IMMUTABLE;`
`86`	`86`
`87`	`87`	`CREATE FUNCTION gtrgm_same(gtrgm, gtrgm, internal)`
`88`	`88`	`RETURNS internal`
`89`	`89`	`AS 'MODULE_PATHNAME'`
`90`		`-LANGUAGE C;`
	`90`	`+LANGUAGE C IMMUTABLE;`
`91`	`91`
`92`	`92`	`-- create the operator class for gist`
`93`	`93`	`CREATE OPERATOR CLASS gist_trgm_ops`
`@@ -107,17 +107,17 @@ AS`
`107`	`107`	`CREATE FUNCTION gin_extract_trgm(text, internal)`
`108`	`108`	`RETURNS internal`
`109`	`109`	`AS 'MODULE_PATHNAME'`
`110`		`-LANGUAGE C;`
	`110`	`+LANGUAGE C IMMUTABLE;`
`111`	`111`
`112`	`112`	`CREATE FUNCTION gin_extract_trgm(text, internal, internal)`
`113`	`113`	`RETURNS internal`
`114`	`114`	`AS 'MODULE_PATHNAME'`
`115`		`-LANGUAGE C;`
	`115`	`+LANGUAGE C IMMUTABLE;`
`116`	`116`
`117`	`117`	`CREATE FUNCTION gin_trgm_consistent(internal, internal, text)`
`118`	`118`	`RETURNS internal`
`119`	`119`	`AS 'MODULE_PATHNAME'`
`120`		`-LANGUAGE C;`
	`120`	`+LANGUAGE C IMMUTABLE;`
`121`	`121`
`122`	`122`	`-- create the operator class for gin`
`123`	`123`	`CREATE OPERATOR CLASS gin_trgm_ops`

`‎contrib/seg/seg.sql.in`

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -323,37 +323,37 @@ CREATE OPERATOR ~ (`
`323`	`323`	`CREATE FUNCTION gseg_consistent(internal,seg,int4)`
`324`	`324`	`RETURNS bool`
`325`	`325`	`AS 'MODULE_PATHNAME'`
`326`		`-LANGUAGE C;`
	`326`	`+LANGUAGE C IMMUTABLE;`
`327`	`327`
`328`	`328`	`CREATE FUNCTION gseg_compress(internal)`
`329`	`329`	`RETURNS internal`
`330`	`330`	`AS 'MODULE_PATHNAME'`
`331`		`-LANGUAGE C;`
	`331`	`+LANGUAGE C IMMUTABLE;`
`332`	`332`
`333`	`333`	`CREATE FUNCTION gseg_decompress(internal)`
`334`	`334`	`RETURNS internal`
`335`	`335`	`AS 'MODULE_PATHNAME'`
`336`		`-LANGUAGE C;`
	`336`	`+LANGUAGE C IMMUTABLE;`
`337`	`337`
`338`	`338`	`CREATE FUNCTION gseg_penalty(internal,internal,internal)`
`339`	`339`	`RETURNS internal`
`340`	`340`	`AS 'MODULE_PATHNAME'`
`341`		`-LANGUAGE C STRICT;`
	`341`	`+LANGUAGE C STRICT IMMUTABLE;`
`342`	`342`
`343`	`343`	`CREATE FUNCTION gseg_picksplit(internal, internal)`
`344`	`344`	`RETURNS internal`
`345`	`345`	`AS 'MODULE_PATHNAME'`
`346`		`-LANGUAGE C;`
	`346`	`+LANGUAGE C IMMUTABLE;`
`347`	`347`
`348`	`348`	`CREATE FUNCTION gseg_union(internal, internal)`
`349`	`349`	`RETURNS seg`
`350`	`350`	`AS 'MODULE_PATHNAME'`
`351`		`-LANGUAGE C;`
	`351`	`+LANGUAGE C IMMUTABLE;`
`352`	`352`
`353`	`353`	`CREATE FUNCTION gseg_same(seg, seg, internal)`
`354`	`354`	`RETURNS internal`
`355`	`355`	`AS 'MODULE_PATHNAME'`
`356`		`-LANGUAGE C;`
	`356`	`+LANGUAGE C IMMUTABLE;`
`357`	`357`
`358`	`358`
`359`	`359`	`-- Create the operator classes for indexing`

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!

Commitf8203f9

File tree

2 files changed

2 files changed

`‎contrib/pg_trgm/pg_trgm.sql.in`

`‎contrib/seg/seg.sql.in`

0 commit comments