|
| 1 | +/* contrib/btree_gist/btree_gist--1.2--1.3.sql*/ |
| 2 | + |
| 3 | +-- complain if script is sourced in psql, rather than via ALTER EXTENSION |
| 4 | +\echo Use"ALTER EXTENSION btree_gist UPDATE TO '1.3'" to load this file. \quit |
| 5 | + |
| 6 | +-- update references to distance operators in pg_amop and pg_depend |
| 7 | + |
| 8 | +WITH |
| 9 | +btree_opsAS ( |
| 10 | +SELECT |
| 11 | +amoplefttype, amoprighttype, amopopr |
| 12 | +FROM |
| 13 | +pg_amop |
| 14 | +JOIN pg_amONpg_am.oid= amopmethod |
| 15 | +JOIN pg_opfamilyONpg_opfamily.oid= amopfamily |
| 16 | +JOIN pg_namespaceONpg_namespace.oid= opfnamespace |
| 17 | +WHERE |
| 18 | +nspname='pg_catalog' |
| 19 | +AND opfnameIN ( |
| 20 | +'integer_ops', |
| 21 | +'oid_ops', |
| 22 | +'money_ops', |
| 23 | +'float_ops', |
| 24 | +'datetime_ops', |
| 25 | +'time_ops', |
| 26 | +'interval_ops' |
| 27 | +) |
| 28 | +AND amname='btree' |
| 29 | +AND amoppurpose='o' |
| 30 | +AND amopstrategy=6 |
| 31 | +), |
| 32 | +gist_opsAS ( |
| 33 | +SELECT |
| 34 | +pg_amop.oidASoid, amoplefttype, amoprighttype, amopopr |
| 35 | +FROM |
| 36 | +pg_amop |
| 37 | +JOIN pg_amON amopmethod=pg_am.oid |
| 38 | +JOIN pg_opfamilyON amopfamily=pg_opfamily.oid |
| 39 | +JOIN pg_namespaceONpg_namespace.oid= opfnamespace |
| 40 | +WHERE |
| 41 | +nspname= current_schema() |
| 42 | +AND opfnameIN ( |
| 43 | +'gist_oid_ops', |
| 44 | +'gist_int2_ops', |
| 45 | +'gist_int4_ops', |
| 46 | +'gist_int8_ops', |
| 47 | +'gist_float4_ops', |
| 48 | +'gist_float8_ops', |
| 49 | +'gist_timestamp_ops', |
| 50 | +'gist_timestamptz_ops', |
| 51 | +'gist_time_ops', |
| 52 | +'gist_date_ops', |
| 53 | +'gist_interval_ops', |
| 54 | +'gist_cash_ops' |
| 55 | +) |
| 56 | +AND amname='gist' |
| 57 | +AND amoppurpose='o' |
| 58 | +AND amopstrategy=15 |
| 59 | +), |
| 60 | +depend_update_data(gist_amop, gist_amopopr, btree_amopopr)AS ( |
| 61 | +SELECT |
| 62 | +gist_ops.oid,gist_ops.amopopr,btree_ops.amopopr |
| 63 | +FROM |
| 64 | +btree_opsJOIN gist_ops USING (amoplefttype, amoprighttype) |
| 65 | +), |
| 66 | +amop_update_dataAS ( |
| 67 | +UPDATE |
| 68 | +pg_depend |
| 69 | +SET |
| 70 | +refobjid= btree_amopopr |
| 71 | +FROM |
| 72 | +depend_update_data |
| 73 | +WHERE |
| 74 | +objid= gist_amopAND refobjid= gist_amopopr |
| 75 | +RETURNING |
| 76 | +depend_update_data.* |
| 77 | +) |
| 78 | +UPDATE |
| 79 | +pg_amop |
| 80 | +SET |
| 81 | +amopopr= btree_amopopr |
| 82 | +FROM |
| 83 | +amop_update_data |
| 84 | +WHERE |
| 85 | +pg_amop.oid= gist_amop; |
| 86 | + |
| 87 | +-- disable implicit pg_catalog search |
| 88 | + |
| 89 | +DO |
| 90 | +$$ |
| 91 | +BEGIN |
| 92 | +EXECUTE'SET LOCAL search_path TO'|| current_schema()||', pg_catalog'; |
| 93 | +END |
| 94 | +$$; |
| 95 | + |
| 96 | +-- drop distance operators |
| 97 | + |
| 98 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (int2, int2); |
| 99 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (int4, int4); |
| 100 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (int8, int8); |
| 101 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (float4, float4); |
| 102 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (float8, float8); |
| 103 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (oid,oid); |
| 104 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (money,money); |
| 105 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (date,date); |
| 106 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (time,time); |
| 107 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (timestamp,timestamp); |
| 108 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (timestamptz,timestamptz); |
| 109 | +ALTER EXTENSION btree_gist DROP OPERATOR<-> (interval, interval); |
| 110 | + |
| 111 | +DROPOPERATOR<-> (int2, int2); |
| 112 | +DROPOPERATOR<-> (int4, int4); |
| 113 | +DROPOPERATOR<-> (int8, int8); |
| 114 | +DROPOPERATOR<-> (float4, float4); |
| 115 | +DROPOPERATOR<-> (float8, float8); |
| 116 | +DROPOPERATOR<-> (oid,oid); |
| 117 | +DROPOPERATOR<-> (money,money); |
| 118 | +DROPOPERATOR<-> (date,date); |
| 119 | +DROPOPERATOR<-> (time,time); |
| 120 | +DROPOPERATOR<-> (timestamp,timestamp); |
| 121 | +DROPOPERATOR<-> (timestamptz,timestamptz); |
| 122 | +DROPOPERATOR<-> (interval, interval); |
| 123 | + |
| 124 | +-- drop distance functions |
| 125 | + |
| 126 | +ALTER EXTENSION btree_gist DROP FUNCTION int2_dist(int2, int2); |
| 127 | +ALTER EXTENSION btree_gist DROP FUNCTION int4_dist(int4, int4); |
| 128 | +ALTER EXTENSION btree_gist DROP FUNCTION int8_dist(int8, int8); |
| 129 | +ALTER EXTENSION btree_gist DROP FUNCTION float4_dist(float4, float4); |
| 130 | +ALTER EXTENSION btree_gist DROP FUNCTION float8_dist(float8, float8); |
| 131 | +ALTER EXTENSION btree_gist DROP FUNCTION oid_dist(oid,oid); |
| 132 | +ALTER EXTENSION btree_gist DROP FUNCTION cash_dist(money,money); |
| 133 | +ALTER EXTENSION btree_gist DROP FUNCTION date_dist(date,date); |
| 134 | +ALTER EXTENSION btree_gist DROP FUNCTION time_dist(time,time); |
| 135 | +ALTER EXTENSION btree_gist DROP FUNCTION ts_dist(timestamp,timestamp); |
| 136 | +ALTER EXTENSION btree_gist DROP FUNCTION tstz_dist(timestamptz,timestamptz); |
| 137 | +ALTER EXTENSION btree_gist DROP FUNCTION interval_dist(interval, interval); |
| 138 | + |
| 139 | +DROPFUNCTION int2_dist(int2, int2); |
| 140 | +DROPFUNCTION int4_dist(int4, int4); |
| 141 | +DROPFUNCTION int8_dist(int8, int8); |
| 142 | +DROPFUNCTION float4_dist(float4, float4); |
| 143 | +DROPFUNCTION float8_dist(float8, float8); |
| 144 | +DROPFUNCTION oid_dist(oid,oid); |
| 145 | +DROPFUNCTION cash_dist(money,money); |
| 146 | +DROPFUNCTION date_dist(date,date); |
| 147 | +DROPFUNCTION time_dist(time,time); |
| 148 | +DROPFUNCTION ts_dist(timestamp,timestamp); |
| 149 | +DROPFUNCTION tstz_dist(timestamptz,timestamptz); |
| 150 | +DROPFUNCTION interval_dist(interval, interval); |