diff options
author | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2012-12-13 13:17:36 -0300 |
---|---|---|
committer | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2012-12-13 13:17:36 -0300 |
commit | c73bcce76532df54ed6e69b8a7903b375810bdf9 (patch) | |
tree | c8f3fd7b83c55178d33e757e98d315fc59e93766 | |
parent | 60398b4fb0abca816c2ea67d61d31616dc4c4eb9 (diff) | |
download | askbot-c73bcce76532df54ed6e69b8a7903b375810bdf9.tar.gz askbot-c73bcce76532df54ed6e69b8a7903b375810bdf9.tar.bz2 askbot-c73bcce76532df54ed6e69b8a7903b375810bdf9.zip |
wrapped tsv column creationss into own transactions in the plpgsql file
-rw-r--r-- | askbot/search/postgresql/thread_and_post_models_27112012.plsql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/askbot/search/postgresql/thread_and_post_models_27112012.plsql b/askbot/search/postgresql/thread_and_post_models_27112012.plsql index 9e90522d..9c328670 100644 --- a/askbot/search/postgresql/thread_and_post_models_27112012.plsql +++ b/askbot/search/postgresql/thread_and_post_models_27112012.plsql @@ -155,10 +155,19 @@ BEGIN END; $$ LANGUAGE plpgsql; -/* create tsvector columns in the content tables */ +/* create tsvector columns in the content tables + need to isolate these into own transactions, b/c of a weird mix + of triggers/update and alter table statements +*/ SELECT add_tsvector_column('text_search_vector', 'askbot_thread'); +COMMIT; +BEGIN; SELECT add_tsvector_column('text_search_vector', 'askbot_post'); +COMMIT; +BEGIN; SELECT add_tsvector_column('title_search_vector', 'askbot_thread'); +COMMIT; +BEGIN; /* populate tsvectors with data */ -- post tsvectors |