@@ -165,7 +165,6 @@ WHERE o.oprleft = t.oid and ( o.oprright = t.oid or o.oprright=tq.oid )
165165-- SELECT * from _int_ops_tmp;
166166
167167-- using the tmp table, generate the amop entries
168- -- note: these operators are all lossy
169168
170169-- _int_overlap
171170INSERT INTO pg_amop (amopclaid, amopstrategy, amopreqcheck, amopopr)
@@ -212,14 +211,6 @@ INSERT INTO pg_amop (amopclaid, amopstrategy, amopreqcheck, amopopr)
212211 and opcname = 'gist__int_ops'
213212 and c.oprname = '@@';
214213
215- INSERT INTO pg_amop (amopclaid, amopstrategy, amopreqcheck, amopopr)
216- SELECT opcl.oid, 20, false, c.opoid
217- FROM pg_opclass opcl, _int_ops_tmp c
218- WHERE
219- opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
220- and opcname = 'gist__int_ops'
221- and c.oprname = '~~';
222-
223214DROP TABLE _int_ops_tmp;
224215
225216
@@ -367,13 +358,6 @@ INSERT INTO pg_amop (amopclaid, amopstrategy, amopreqcheck, amopopr)
367358 opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
368359 and opcname = 'gist__intbig_ops'
369360 and c.oprname = '@@';
370- INSERT INTO pg_amop (amopclaid, amopstrategy, amopreqcheck, amopopr)
371- SELECT opcl.oid, 20, true, c.opoid
372- FROM pg_opclass opcl, _int_ops_tmp c
373- WHERE
374- opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
375- and opcname = 'gist__intbig_ops'
376- and c.oprname = '~~';
377361
378362DROP TABLE _int_ops_tmp;
379363