NotificationsYou must be signed in to change notification settings
Fork28
Star153

Commitd80d8ac

committed

Support functions for index opclasses should be immutable.

Found by running opr_sanity on contrib modules.

1 parent9226630 commitd80d8acCopy full SHA for d80d8ac

File tree

1 file changed

+11

-11

lines changed

contrib/hstore
- hstore.sql.in

1 file changed

+11

-11

lines changed

`‎contrib/hstore/hstore.sql.in‎`

Lines changed: 11 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -186,37 +186,37 @@ CREATE TYPE ghstore (`
`186`	`186`	`CREATE FUNCTION ghstore_compress(internal)`
`187`	`187`	`RETURNS internal`
`188`	`188`	`AS 'MODULE_PATHNAME'`
`189`		`-LANGUAGE C;`
	`189`	`+LANGUAGE C IMMUTABLE;`
`190`	`190`
`191`	`191`	`CREATE FUNCTION ghstore_decompress(internal)`
`192`	`192`	`RETURNS internal`
`193`	`193`	`AS 'MODULE_PATHNAME'`
`194`		`-LANGUAGE C;`
	`194`	`+LANGUAGE C IMMUTABLE;`
`195`	`195`
`196`	`196`	`CREATE FUNCTION ghstore_penalty(internal,internal,internal)`
`197`	`197`	`RETURNS internal`
`198`	`198`	`AS 'MODULE_PATHNAME'`
`199`		`-LANGUAGE C STRICT;`
	`199`	`+LANGUAGE CIMMUTABLESTRICT;`
`200`	`200`
`201`	`201`	`CREATE FUNCTION ghstore_picksplit(internal, internal)`
`202`	`202`	`RETURNS internal`
`203`	`203`	`AS 'MODULE_PATHNAME'`
`204`		`-LANGUAGE C;`
	`204`	`+LANGUAGE C IMMUTABLE;`
`205`	`205`
`206`	`206`	`CREATE FUNCTION ghstore_union(internal, internal)`
`207`	`207`	`RETURNS internal`
`208`	`208`	`AS 'MODULE_PATHNAME'`
`209`		`-LANGUAGE C;`
	`209`	`+LANGUAGE C IMMUTABLE;`
`210`	`210`
`211`	`211`	`CREATE FUNCTION ghstore_same(internal, internal, internal)`
`212`	`212`	`RETURNS internal`
`213`	`213`	`AS 'MODULE_PATHNAME'`
`214`		`-LANGUAGE C;`
	`214`	`+LANGUAGE C IMMUTABLE;`
`215`	`215`
`216`	`216`	`CREATE FUNCTION ghstore_consistent(internal,internal,int4)`
`217`	`217`	`RETURNS bool`
`218`	`218`	`AS 'MODULE_PATHNAME'`
`219`		`-LANGUAGE C;`
	`219`	`+LANGUAGE C IMMUTABLE;`
`220`	`220`
`221`	`221`	`-- register the opclass for indexing (not as default)`
`222`	`222`	`CREATE OPERATOR CLASS gist_hstore_ops`
`@@ -241,23 +241,23 @@ AS`
`241`	`241`	`CREATE FUNCTION gin_extract_hstore(internal, internal)`
`242`	`242`	`RETURNS internal`
`243`	`243`	`AS 'MODULE_PATHNAME'`
`244`		`-LANGUAGE C;`
	`244`	`+LANGUAGE C IMMUTABLE;`
`245`	`245`
`246`	`246`	`CREATE FUNCTION gin_extract_hstore_query(internal, internal, int2)`
`247`	`247`	`RETURNS internal`
`248`	`248`	`AS 'MODULE_PATHNAME'`
`249`		`-LANGUAGE C;`
	`249`	`+LANGUAGE C IMMUTABLE;`
`250`	`250`
`251`	`251`	`CREATE FUNCTION gin_consistent_hstore(internal, int2, internal)`
`252`	`252`	`RETURNS internal`
`253`	`253`	`AS 'MODULE_PATHNAME'`
`254`		`-LANGUAGE C;`
	`254`	`+LANGUAGE C IMMUTABLE;`
`255`	`255`
`256`	`256`	`CREATE OPERATOR CLASS gin_hstore_ops`
`257`	`257`	`DEFAULT FOR TYPE hstore USING gin`
`258`	`258`	`AS`
`259`	`259`	`OPERATOR 7 @> RECHECK,`
`260`		`-OPERATOR 9 ?(hstore,text),`
	`260`	`+OPERATOR 9 ?(hstore,text),`
`261`	`261`	`FUNCTION 1 bttextcmp(text,text),`
`262`	`262`	`FUNCTION 2 gin_extract_hstore(internal, internal),`
`263`	`263`	`FUNCTION 3 gin_extract_hstore_query(internal, internal, int2),`

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!

Commitd80d8ac

File tree

1 file changed

1 file changed

`‎contrib/hstore/hstore.sql.in‎`

0 commit comments