From d07f8c25994aeee3531b4c08573ffd27f60258f8 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 20 Nov 2011 16:59:06 -0500 Subject: [PATCH 1/1] Revert the functional index on players table. It won't be used with LIKE query anyway. --- tables/players.tab | 2 -- 1 file changed, 2 deletions(-) diff --git a/tables/players.tab b/tables/players.tab index db38ce4..b75a53a 100644 --- a/tables/players.tab +++ b/tables/players.tab @@ -11,5 +11,3 @@ WITH ( OIDS=FALSE ); ALTER TABLE xonstat.players OWNER TO xonstat; - -CREATE INDEX players_ix01 ON players ((upper(stripped_nick)); -- 2.39.2