Kouhei Sutou
null+****@clear*****
Thu Aug 17 12:49:26 JST 2017
Kouhei Sutou 2017-08-17 12:49:26 +0900 (Thu, 17 Aug 2017) New Revision: 6e0569c10d3969730093f2a52529cae7442bac91 https://github.com/pgroonga/pgroonga/commit/6e0569c10d3969730093f2a52529cae7442bac91 Message: Fix upgrade failure on PostgreSQL 9.5 or ealier Modified files: data/pgroonga--1.2.3--2.0.0.sql Modified: data/pgroonga--1.2.3--2.0.0.sql (+15 -33) =================================================================== --- data/pgroonga--1.2.3--2.0.0.sql 2017-08-17 12:49:13 +0900 (ce83ba6) +++ data/pgroonga--1.2.3--2.0.0.sql 2017-08-17 12:49:26 +0900 (e0537eb) @@ -1097,39 +1097,21 @@ EXCEPTION AS 'MODULE_PATHNAME', 'pgroonga_options' LANGUAGE C; - DELETE FROM pg_am WHERE amname = 'pgroonga'; - INSERT INTO pg_am VALUES( - 'pgroonga', -- amname - 30, -- amstrategies - 0, -- amsupport - true, -- amcanorder - true, -- amcanorderbyop - true, -- amcanbackward - true, -- amcanunique - true, -- amcanmulticol - true, -- amoptionalkey - true, -- amsearcharray - false, -- amsearchnulls - false, -- amstorage - true, -- amclusterable - false, -- ampredlocks - 0, -- amkeytype - 'pgroonga_insert', -- aminsert - 'pgroonga_beginscan', -- ambeginscan - 'pgroonga_gettuple', -- amgettuple - 'pgroonga_getbitmap', -- amgetbitmap - 'pgroonga_rescan', -- amrescan - 'pgroonga_endscan', -- amendscan - 0, -- ammarkpos, - 0, -- amrestrpos, - 'pgroonga_build', -- ambuild - 'pgroonga_buildempty', -- ambuildempty - 'pgroonga_bulkdelete', -- ambulkdelete - 'pgroonga_vacuumcleanup', -- amvacuumcleanup - 'pgroonga_canreturn', -- amcanreturn - 'pgroonga_costestimate', -- amcostestimate - 'pgroonga_options' -- amoptions - ); + UPDATE pg_catalog.pg_am + SET aminsert = 'pgroonga_insert', + ambeginscan = 'pgroonga_beginscan', + amgettuple = 'pgroonga_gettuple', + amgetbitmap = 'pgroonga_getbitmap', + amrescan = 'pgroonga_rescan', + amendscan = 'pgroonga_endscan', + ambuild = 'pgroonga_build', + ambuildempty = 'pgroonga_buildempty', + ambulkdelete = 'pgroonga_bulkdelete', + amvacuumcleanup = 'pgroonga_vacuumcleanup', + amcanreturn = 'pgroonga_canreturn', + amcostestimate = 'pgroonga_costestimate', + amoptions = 'pgroonga_options' + WHERE amname = 'pgroonga'; END; $$; -------------- next part -------------- HTML����������������������������...下载
