gistfile1.txt

[propertyforeman] psql propertyforeman-dev < db/propertyforeman-dev.psql                                                        22:48:55  ☁  landlord_tasks ☂ ✭
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
SET
SET
SET
ERROR:  relation "applicants" already exists
ERROR:  relation "applicants_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "images" already exists
CREATE SEQUENCE
ALTER SEQUENCE
ERROR:  relation "invoices" already exists
ERROR:  relation "invoices_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "items" already exists
ERROR:  relation "items_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "landlords" already exists
ERROR:  relation "landlords_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "messages" already exists
ERROR:  relation "messages_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "properties" already exists
ERROR:  relation "properties_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "schema_migrations" already exists
ERROR:  relation "slots" already exists
ERROR:  relation "slots_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "taggings" already exists
ERROR:  relation "taggings_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "tags" already exists
ERROR:  relation "tags_id_seq" already exists
ALTER SEQUENCE
ERROR:  relation "users" already exists
ERROR:  relation "users_id_seq" already exists
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
 setval 
--------
      1
(1 row)

 setval 
--------
     29
(1 row)

 setval 
--------
      5
(1 row)

 setval 
--------
      4
(1 row)

ERROR:  column "account_payment_receive_verification_uri" of relation "landlords" does not exist
invalid command \N
invalid command \N
invalid command \.
ERROR:  syntax error at or near "3"
LINE 1: 3 Test Landlord 2012-03-01 05:37:12 2012-08-15 03:32:56 test...
        ^
 setval 
--------
      1
(1 row)

 setval 
--------
     16
(1 row)

ERROR:  duplicate key value violates unique constraint "unique_schema_migrations"
DETAIL:  Key (version)=(20120128032057) already exists.
CONTEXT:  COPY schema_migrations, line 41: ""
 setval 
--------
      3
(1 row)

 setval 
--------
      9
(1 row)

 setval 
--------
      9
(1 row)

 setval 
--------
      2
(1 row)

ERROR:  multiple primary keys for table "applicants" are not allowed
ERROR:  multiple primary keys for table "images" are not allowed
ERROR:  multiple primary keys for table "invoices" are not allowed
ERROR:  multiple primary keys for table "items" are not allowed
ERROR:  multiple primary keys for table "landlords" are not allowed
ERROR:  multiple primary keys for table "messages" are not allowed
ERROR:  multiple primary keys for table "properties" are not allowed
ALTER TABLE
ERROR:  multiple primary keys for table "slots" are not allowed
ERROR:  multiple primary keys for table "taggings" are not allowed
ERROR:  multiple primary keys for table "tags" are not allowed
ERROR:  multiple primary keys for table "users" are not allowed
ERROR:  relation "index_images_on_attachable_id" already exists
ERROR:  relation "index_landlords_on_authentication_token" already exists
ERROR:  relation "index_landlords_on_confirmation_token" already exists
ERROR:  relation "index_landlords_on_email" already exists
ERROR:  relation "index_landlords_on_reset_password_token" already exists
ERROR:  relation "index_landlords_on_unlock_token" already exists
ERROR:  relation "index_messages_on_landlord_id" already exists
ERROR:  relation "index_messages_on_user_id" already exists
ERROR:  relation "index_properties_on_user_id" already exists
ERROR:  relation "index_slots_on_property_id" already exists
ERROR:  relation "index_slots_on_user_id" already exists
ERROR:  relation "index_taggings_on_tag_id" already exists
ERROR:  relation "index_taggings_on_taggable_id_and_taggable_type_and_context" already exists
ERROR:  relation "index_users_on_authentication_token" already exists
ERROR:  relation "index_users_on_confirmation_token" already exists
ERROR:  relation "index_users_on_email" already exists
ERROR:  relation "index_users_on_reset_password_token" already exists
ERROR:  relation "index_users_on_unlock_token" already exists
ERROR:  relation "unique_schema_migrations" already exists