diff options
| author | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2012-03-12 00:12:40 -0400 |
|---|---|---|
| committer | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2012-03-12 00:12:40 -0400 |
| commit | 92f99bb3b08ab0181ab90cc5019862b38ff2c18c (patch) | |
| tree | 90b2500e53b9a14352498547706b491fc88dcd0d | |
| parent | f8a1d9d49d98bffb77d945314550c1b80841576d (diff) | |
| download | askbot-92f99bb3b08ab0181ab90cc5019862b38ff2c18c.tar.gz askbot-92f99bb3b08ab0181ab90cc5019862b38ff2c18c.tar.bz2 askbot-92f99bb3b08ab0181ab90cc5019862b38ff2c18c.zip | |
added drop function statements to new fts setup for postgres, hopefully it works for postgres 9
| -rw-r--r-- | askbot/search/postgresql/thread_and_post_models_01162012.plsql | 2 |
1 files changed, 2 insertions, 0 deletions
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 $$ |