Skip to content

Instantly share code, notes, and snippets.

@ibrahima
Created April 9, 2012 02:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ibrahima/3f7110fc38a3ccc7edcb to your computer and use it in GitHub Desktop.
Save ibrahima/3f7110fc38a3ccc7edcb to your computer and use it in GitHub Desktop.
manually run migration output
$ psql -U ibrahim -f thread_and_post_models_01162012.plsql
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
setup_aggregates
------------------
t
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:122: NOTICE: function get_dependent_comments_tsv(pg_catalog.int4,text) does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:140: NOTICE: function get_dependent_answers_tsv(pg_catalog.int4) does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:159: ERROR: relation "askbot_thread" does not exist
CONTEXT: SQL statement "ALTER TABLE askbot_thread ADD COLUMN text_search_vector tsvector"
PL/pgSQL function "add_tsvector_column" line 7 at EXECUTE statement
psql:thread_and_post_models_01162012.plsql:160: ERROR: relation "askbot_post" does not exist
CONTEXT: SQL statement "ALTER TABLE askbot_post ADD COLUMN text_search_vector tsvector"
PL/pgSQL function "add_tsvector_column" line 7 at EXECUTE statement
psql:thread_and_post_models_01162012.plsql:164: ERROR: relation "askbot_post" does not exist
LINE 3: UPDATE askbot_post set text_search_vector = get_post_tsv(tex...
^
psql:thread_and_post_models_01162012.plsql:165: ERROR: relation "askbot_post" does not exist
LINE 1: UPDATE askbot_post SET text_search_vector = get_post_tsv(tex...
^
psql:thread_and_post_models_01162012.plsql:166: ERROR: relation "askbot_post" does not exist
LINE 1: UPDATE askbot_post SET text_search_vector = get_post_tsv(tex...
^
psql:thread_and_post_models_01162012.plsql:168: ERROR: relation "askbot_post" does not exist
LINE 1: UPDATE askbot_post as q SET text_search_vector = text_search...
^
psql:thread_and_post_models_01162012.plsql:171: ERROR: relation "askbot_thread" does not exist
LINE 1: UPDATE askbot_thread SET text_search_vector = get_thread_tsv...
^
psql:thread_and_post_models_01162012.plsql:174: ERROR: relation "askbot_thread" does not exist
LINE 1: UPDATE askbot_thread as t SET text_search_vector = text_sear...
^
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:188: ERROR: relation "askbot_thread" does not exist
psql:thread_and_post_models_01162012.plsql:190: ERROR: relation "askbot_thread" does not exist
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:199: ERROR: relation "askbot_thread" does not exist
psql:thread_and_post_models_01162012.plsql:201: ERROR: relation "askbot_thread" does not exist
CREATE FUNCTION
psql:thread_and_post_models_01162012.plsql:220: ERROR: relation "askbot_post" does not exist
psql:thread_and_post_models_01162012.plsql:222: ERROR: relation "askbot_post" does not exist
psql:thread_and_post_models_01162012.plsql:224: NOTICE: index "askbot_search_idx" does not exist, skipping
DROP INDEX
psql:thread_and_post_models_01162012.plsql:225: ERROR: relation "askbot_thread" does not exist
ibrahim@envy14:/usr/local/lib/python2.7/dist-packages/askbot/search/postgresql 07:20:13 Sun Apr 08
$ psql
psql (9.1.3)
Type "help" for help.
ibrahim=# CREATE LANGUAGE plpgsql;
ERROR: language "plpgsql" already exists
ibrahim=# \quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment