Kouhei Sutou
null+****@clear*****
Wed Oct 28 22:36:20 JST 2015
Kouhei Sutou 2015-10-28 22:36:20 +0900 (Wed, 28 Oct 2015) New Revision: 53fddca84f95e3691487de46576110d2cb1332e5 https://github.com/pgroonga/pgroonga/commit/53fddca84f95e3691487de46576110d2cb1332e5 Message: Remove migration file Removed files: pgroonga--0.8.0--0.9.0.sql pgroonga--0.9.0--1.0.0.sql Modified files: Makefile Modified: Makefile (+3 -2) =================================================================== --- Makefile 2015-10-28 22:28:44 +0900 (da99112) +++ Makefile 2015-10-28 22:36:20 +0900 (9f00536) @@ -11,8 +11,9 @@ EXTENSION_VERSION = \ $(shell grep default_version $(EXTENSION).control | \ sed -e "s/^.*'\([0-9.]*\)'$$/\1/") DATA = \ - pgroonga--$(EXTENSION_VERSION).sql \ - $(shell echo pgroonga--*--*.sql) + pgroonga--$(EXTENSION_VERSION).sql +# $(shell echo pgroonga--*--*.sql) + PG_CPPFLAGS = $(shell pkg-config --cflags $(GROONGA_PKG)) SHLIB_LINK = $(shell pkg-config --libs $(GROONGA_PKG)) -lm REGRESS = $(shell find sql -name '*.sql' | sed -e 's,\(^sql/\|\.sql$$\),,g') Deleted: pgroonga--0.8.0--0.9.0.sql (+0 -30) 100644 =================================================================== --- pgroonga--0.8.0--0.9.0.sql 2015-10-28 22:28:44 +0900 (09fdc6e) +++ /dev/null @@ -1,30 +0,0 @@ -UPDATE pg_catalog.pg_am SET amstrategies = 9 WHERE amname = 'pgroonga'; - -DO LANGUAGE plpgsql $$ -BEGIN - PERFORM 1 - FROM pg_type - WHERE typname = 'jsonb'; - - IF FOUND - THEN - CREATE FUNCTION pgroonga.match(jsonb, text) - RETURNS bool - AS 'MODULE_PATHNAME', 'pgroonga_match_jsonb' - LANGUAGE C - IMMUTABLE - STRICT; - - CREATE OPERATOR @@ ( - PROCEDURE = pgroonga.match, - LEFTARG = jsonb, - RIGHTARG = text - ); - - CREATE OPERATOR CLASS pgroonga.jsonb_ops DEFAULT FOR TYPE jsonb - USING pgroonga AS - OPERATOR 8 @@ (jsonb, text), - OPERATOR 9 @>; - END IF; -END; -$$; Deleted: pgroonga--0.9.0--1.0.0.sql (+0 -48) 100644 =================================================================== --- pgroonga--0.9.0--1.0.0.sql 2015-10-28 22:28:44 +0900 (51ae786) +++ /dev/null @@ -1,48 +0,0 @@ --- Support index only scan -CREATE FUNCTION pgroonga.canreturn(internal) - RETURNS internal - AS 'MODULE_PATHNAME', 'pgroonga_canreturn' - LANGUAGE C; - -UPDATE pg_catalog.pg_am - SET amcanreturn = 'pgroonga.canreturn' - WHERE amname = 'pgroonga'; - - --- Support @~ -UPDATE pg_catalog.pg_am SET amstrategies = 10 WHERE amname = 'pgroonga'; - -CREATE FUNCTION pgroonga.match_regexp(text, text) - RETURNS bool - AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_text' - LANGUAGE C - IMMUTABLE - STRICT; - -CREATE FUNCTION pgroonga.match_regexp(varchar, varchar) - RETURNS bool - AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_varchar' - LANGUAGE C - IMMUTABLE - STRICT; - -CREATE OPERATOR @~ ( - PROCEDURE = pgroonga.match_regexp, - LEFTARG = text, - RIGHTARG = text -); - -CREATE OPERATOR @~ ( - PROCEDURE = pgroonga.match_regexp, - LEFTARG = varchar, - RIGHTARG = varchar -); - -CREATE OPERATOR CLASS pgroonga.text_regexp_ops FOR TYPE text - USING pgroonga AS - OPERATOR 6 pg_catalog.~~, - OPERATOR 10 @~; - -CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops FOR TYPE varchar - USING pgroonga AS - OPERATOR 10 @~; -------------- next part -------------- HTML����������������������������...Download