From 92f99bb3b08ab0181ab90cc5019862b38ff2c18c Mon Sep 17 00:00:00 2001
From: Evgeny Fadeev <evgeny.fadeev@gmail.com>
Date: Mon, 12 Mar 2012 00:12:40 -0400
Subject: added drop function statements to new fts setup for postgres,
 hopefully it works for postgres 9

---
 askbot/search/postgresql/thread_and_post_models_01162012.plsql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/askbot/search/postgresql/thread_and_post_models_01162012.plsql b/askbot/search/postgresql/thread_and_post_models_01162012.plsql
index 44d0ea4a..2fca2d6a 100644
--- a/askbot/search/postgresql/thread_and_post_models_01162012.plsql
+++ b/askbot/search/postgresql/thread_and_post_models_01162012.plsql
@@ -119,6 +119,7 @@ BEGIN
 END;
 $$ LANGUAGE plpgsql;
 
+DROP FUNCTION IF EXISTS get_dependent_comments_tsv(object_id integer, tablename text);
 CREATE OR REPLACE FUNCTION get_dependent_comments_tsv(parent_id integer)
 RETURNS tsvector AS
 $$
@@ -136,6 +137,7 @@ BEGIN
 END;
 $$ LANGUAGE plpgsql;
 
+DROP FUNCTION IF EXISTS get_dependent_answers_tsv(question_id integer);
 CREATE OR REPLACE FUNCTION get_dependent_answers_tsv(thread_id integer)
 RETURNS tsvector AS
 $$
-- 
cgit v1.2.3-1-g7c22