messages_txt -> messages

1 files changed, 2 insertions, 6 deletions

diff --git a/src/main/java/com/juick/service/PostgresSearchService.java b/src/main/java/com/juick/service/PostgresSearchService.java
index 500f3d20..2493a45e 100644
--- a/src/main/java/com/juick/service/PostgresSearchService.java
+++ b/src/main/java/com/juick/service/PostgresSearchService.java
@@ -70,14 +70,10 @@ public class PostgresSearchService extends BaseJdbcService implements SearchServ
                                   FROM
                                     (
                                       select
-                                        messages.message_id message_id,
-                                        messages.user_id user_id,
-                                        txt,
+                                        message_id,  user_id, txt,
                                         to_tsvector('russian', txt) v,
                                         websearch_to_tsquery('russian', :query) q
-                                      from
-                                        messages_txt
-                                        inner join messages on messages.message_id = messages_txt.message_id
+                                      from messages
                                     ) t
                                   WHERE
                                     v @@ q