-
-
Save ibrahima/3f7110fc38a3ccc7edcb to your computer and use it in GitHub Desktop.
manually run migration output
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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