API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 21st, 2015
199
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.97 KB | None | 0 0
raw download clone embed print report
  1. $ wisms_init_db development.ini
  2. 2015-04-21 16:04:47,348 ERROR [vistula.system.databases.sqlalchemyorm][MainThread] Error: (DataError) value too long for type character varying(50)
  3. 'INSERT INTO sites (public_id, is_active, version_no, created_by, created_date, updated_by, updated_date, local_authority_id, wi_region_id, organisation_id, county_id, waste_region_id, cp_category_id, fts_index, fts_indexed_date, name, la_reg_no, is_collection_site, is_treatment_site, is_local_authority, is_address, line_1, line_2, city, post_code, lat, lng, contact_1_status, contact_1_token, contact_1_type, contact_1_name, contact_1_email, contact_1_tel, contact_2_status, contact_2_token, contact_2_type, contact_2_name, contact_2_email, contact_2_tel) VALUES (%(public_id)s, %(is_active)s, %(version_no)s, %(created_by)s, %(created_date)s, %(updated_by)s, %(updated_date)s, %(local_authority_id)s, %(wi_region_id)s, %(organisation_id)s, %(county_id)s, %(waste_region_id)s, %(cp_category_id)s, %(fts_index)s, %(fts_indexed_date)s, %(name)s, %(la_reg_no)s, %(is_collection_site)s, %(is_treatment_site)s, %(is_local_authority)s, %(is_address)s, %(line_1)s, %(line_2)s, %(city)s, %(post_code)s, %(lat)s, %(lng)s, %(contact_1_status)s, %(contact_1_token)s, %(contact_1_type)s, %(contact_1_name)s, %(contact_1_email)s, %(contact_1_tel)s, %(contact_2_status)s, %(contact_2_token)s, %(contact_2_type)s, %(contact_2_name)s, %(contact_2_email)s, %(contact_2_tel)s) RETURNING sites.id' {'contact_2_type': u'both', 'public_id': u'Ballymount_CAS102', 'waste_region_id': 3, 'version_no': 1, 'county_id': 6, 'lng': None, 'contact_2_email': u'john.richardson@veolia.ie', 'city': u'Dublin ', 'contact_1_tel': u'014621251', 'contact_1_status': u'pending', 'fts_index': None, 'is_address': False, 'created_by': u'test_data', 'is_local_authority': False, 'contact_1_email': u'ebuttle@sdublincoco.ie', 'line_1': u'Ballymount Avenue Upper, Ballymount Industrial Estate', 'line_2': u'Ballymount', 'contact_2_tel': u'', 'updated_date': None, 'post_code': u'Dublin 12', 'updated_by': None, 'organisation_id': 1, 'wi_region_id': 5, 'created_date': datetime.datetime(2015, 4, 21, 13, 4, 5, 957086), 'is_active': True, 'cp_category_id': 7, 'la_reg_no': None, 'local_authority_id': 27, 'lat': None, 'fts_indexed_date': None, 'is_treatment_site': False, 'is_collection_site': True, 'name': u'Ballymount CAS', 'contact_2_token': None, 'contact_1_name': u'Eoin Buttle', 'contact_2_name': u'', 'contact_1_token': None, 'contact_2_status': u'inactive', 'contact_1_type': u'both'}
  4. 2015-04-21 16:04:47,348 ERROR [vistula.system.databases.sqlalchemyorm][MainThread] Error while loading initial data ((DataError) value too long for type character varying(50)
  5. 'INSERT INTO sites (public_id, is_active, version_no, created_by, created_date, updated_by, updated_date, local_authority_id, wi_region_id, organisation_id, county_id, waste_region_id, cp_category_id, fts_index, fts_indexed_date, name, la_reg_no, is_collection_site, is_treatment_site, is_local_authority, is_address, line_1, line_2, city, post_code, lat, lng, contact_1_status, contact_1_token, contact_1_type, contact_1_name, contact_1_email, contact_1_tel, contact_2_status, contact_2_token, contact_2_type, contact_2_name, contact_2_email, contact_2_tel) VALUES (%(public_id)s, %(is_active)s, %(version_no)s, %(created_by)s, %(created_date)s, %(updated_by)s, %(updated_date)s, %(local_authority_id)s, %(wi_region_id)s, %(organisation_id)s, %(county_id)s, %(waste_region_id)s, %(cp_category_id)s, %(fts_index)s, %(fts_indexed_date)s, %(name)s, %(la_reg_no)s, %(is_collection_site)s, %(is_treatment_site)s, %(is_local_authority)s, %(is_address)s, %(line_1)s, %(line_2)s, %(city)s, %(post_code)s, %(lat)s, %(lng)s, %(contact_1_status)s, %(contact_1_token)s, %(contact_1_type)s, %(contact_1_name)s, %(contact_1_email)s, %(contact_1_tel)s, %(contact_2_status)s, %(contact_2_token)s, %(contact_2_type)s, %(contact_2_name)s, %(contact_2_email)s, %(contact_2_tel)s) RETURNING sites.id' {'contact_2_type': u'both', 'public_id': u'Ballymount_CAS102', 'waste_region_id': 3, 'version_no': 1, 'county_id': 6, 'lng': None, 'contact_2_email': u'john.richardson@veolia.ie', 'city': u'Dublin ', 'contact_1_tel': u'014621251', 'contact_1_status': u'pending', 'fts_index': None, 'is_address': False, 'created_by': u'test_data', 'is_local_authority': False, 'contact_1_email': u'ebuttle@sdublincoco.ie', 'line_1': u'Ballymount Avenue Upper, Ballymount Industrial Estate', 'line_2': u'Ballymount', 'contact_2_tel': u'', 'updated_date': None, 'post_code': u'Dublin 12', 'updated_by': None, 'organisation_id': 1, 'wi_region_id': 5, 'created_date': datetime.datetime(2015, 4, 21, 13, 4, 5, 957086), 'is_active': True, 'cp_category_id': 7, 'la_reg_no': None, 'local_authority_id': 27, 'lat': None, 'fts_indexed_date': None, 'is_treatment_site': False, 'is_collection_site': True, 'name': u'Ballymount CAS', 'contact_2_token': None, 'contact_1_name': u'Eoin Buttle', 'contact_2_name': u'', 'contact_1_token': None, 'contact_2_status': u'inactive', 'contact_1_type': u'both'})
  6. 2015-04-21 16:04:47,348 DEBUG [vistula.system.action][MainThread] Action: About to rollback...
  7. 2015-04-21 16:04:47,348 DEBUG [vistula.system.action][MainThread] Action: Rolling back <sqlalchemy.orm.session.Session object at 0x66d5fd0>
  8. 2015-04-21 16:04:47,349 DEBUG [vistula.system.action][MainThread] Action: Rolled back <sqlalchemy.orm.session.Session object at 0x66d5fd0>
  9. 2015-04-21 16:04:47,349 DEBUG [vistula.system.action][MainThread] Action: Rolled back.
  10. Traceback (most recent call last):
  11. File "/home/r05/prog/wisms/venv/bin/wisms_init_db", line 9, in <module>
  12. load_entry_point('WISMS==0.1dev', 'console_scripts', 'wisms_init_db')()
  13. File "/home/r05/prog/wisms/WISMS/wisms/scripts/init_db.py", line 19, in main
  14. installer.load_test_data()
  15. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/vistula-0.10-py2.7.egg/vistula/system/frontends/installer.py", line 49, in load_test_data
  16. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/vistula-0.10-py2.7.egg/vistula/system/databases/sqlalchemyorm.py", line 113, in load_test_data
  17. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 1985, in flush
  18. self._flush(objects)
  19. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 2103, in _flush
  20. transaction.rollback(_capture_exception=True)
  21. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  22. compat.reraise(exc_type, exc_value, exc_tb)
  23. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 2067, in _flush
  24. flush_context.execute()
  25. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/unitofwork.py", line 367, in execute
  26. n.execute_aggregate(self, set_)
  27. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/unitofwork.py", line 620, in execute_aggregate
  28. uow)
  29. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/persistence.py", line 65, in save_obj
  30. mapper, table, insert)
  31. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/persistence.py", line 602, in _emit_insert_statements
  32. execute(statement, params)
  33. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 841, in execute
  34. return meth(self, multiparams, params)
  35. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
  36. return connection._execute_clauseelement(self, multiparams, params)
  37. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 938, in _execute_clauseelement
  38. compiled_sql, distilled_params
  39. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1070, in _execute_context
  40. context)
  41. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1271, in _handle_dbapi_exception
  42. exc_info
  43. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 199, in raise_from_cause
  44. reraise(type(exception), exception, tb=exc_tb)
  45. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1063, in _execute_context
  46. context)
  47. File "/home/r05/prog/wisms/venv/local/lib/python2.7/site-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 442, in do_execute
  48. cursor.execute(statement, parameters)
  49. sqlalchemy.exc.DataError: (DataError) value too long for type character varying(50)
  50. 'INSERT INTO sites (public_id, is_active, version_no, created_by, created_date, updated_by, updated_date, local_authority_id, wi_region_id, organisation_id, county_id, waste_region_id, cp_category_id, fts_index, fts_indexed_date, name, la_reg_no, is_collection_site, is_treatment_site, is_local_authority, is_address, line_1, line_2, city, post_code, lat, lng, contact_1_status, contact_1_token, contact_1_type, contact_1_name, contact_1_email, contact_1_tel, contact_2_status, contact_2_token, contact_2_type, contact_2_name, contact_2_email, contact_2_tel) VALUES (%(public_id)s, %(is_active)s, %(version_no)s, %(created_by)s, %(created_date)s, %(updated_by)s, %(updated_date)s, %(local_authority_id)s, %(wi_region_id)s, %(organisation_id)s, %(county_id)s, %(waste_region_id)s, %(cp_category_id)s, %(fts_index)s, %(fts_indexed_date)s, %(name)s, %(la_reg_no)s, %(is_collection_site)s, %(is_treatment_site)s, %(is_local_authority)s, %(is_address)s, %(line_1)s, %(line_2)s, %(city)s, %(post_code)s, %(lat)s, %(lng)s, %(contact_1_status)s, %(contact_1_token)s, %(contact_1_type)s, %(contact_1_name)s, %(contact_1_email)s, %(contact_1_tel)s, %(contact_2_status)s, %(contact_2_token)s, %(contact_2_type)s, %(contact_2_name)s, %(contact_2_email)s, %(contact_2_tel)s) RETURNING sites.id' {'contact_2_type': u'both', 'public_id': u'Ballymount_CAS102', 'waste_region_id': 3, 'version_no': 1, 'county_id': 6, 'lng': None, 'contact_2_email': u'john.richardson@veolia.ie', 'city': u'Dublin ', 'contact_1_tel': u'014621251', 'contact_1_status': u'pending', 'fts_index': None, 'is_address': False, 'created_by': u'test_data', 'is_local_authority': False, 'contact_1_email': u'ebuttle@sdublincoco.ie', 'line_1': u'Ballymount Avenue Upper, Ballymount Industrial Estate', 'line_2': u'Ballymount', 'contact_2_tel': u'', 'updated_date': None, 'post_code': u'Dublin 12', 'updated_by': None, 'organisation_id': 1, 'wi_region_id': 5, 'created_date': datetime.datetime(2015, 4, 21, 13, 4, 5, 957086), 'is_active': True, 'cp_category_id': 7, 'la_reg_no': None, 'local_authority_id': 27, 'lat': None, 'fts_indexed_date': None, 'is_treatment_site': False, 'is_collection_site': True, 'name': u'Ballymount CAS', 'contact_2_token': None, 'contact_1_name': u'Eoin Buttle', 'contact_2_name': u'', 'contact_1_token': None, 'contact_2_status': u'inactive', 'contact_1_type': u'both'}
  51.  
  52.  
  53.  
  54. $ psql wismsdb < test_69_dump_1.sql
  55. ERROR: duplicate key value violates unique constraint "categories_pkey"
  56. DETAIL: Key (id)=(1) already exists.
  57. CONTEXT: COPY categories, line 1
  58. ERROR: insert or update on table "collection_contracts" violates foreign key constraint "collection_contracts_contractor_id_fkey"
  59. DETAIL: Key (contractor_id)=(7) is not present in table "organisations".
  60. ERROR: insert or update on table "collection_price" violates foreign key constraint "collection_price_item_id_fkey"
  61. DETAIL: Key (item_id)=(6050) is not present in table "items".
  62. ERROR: insert or update on table "collection_rules" violates foreign key constraint "collection_rules_contract_id_fkey"
  63. DETAIL: Key (contract_id)=(3) is not present in table "collection_contracts".
  64. ERROR: insert or update on table "collections" violates foreign key constraint "collections_load_id_fkey"
  65. DETAIL: Key (load_id)=(1) is not present in table "loads".
  66. ERROR: duplicate key value violates unique constraint "container_types_pkey"
  67. DETAIL: Key (id)=(1) already exists.
  68. CONTEXT: COPY container_types, line 1
  69. ERROR: duplicate key value violates unique constraint "counties_pkey"
  70. DETAIL: Key (id)=(1) already exists.
  71. CONTEXT: COPY counties, line 1
  72. ERROR: insert or update on table "deliveries" violates foreign key constraint "deliveries_load_id_fkey"
  73. DETAIL: Key (load_id)=(1) is not present in table "loads".
  74. ERROR: duplicate key value violates unique constraint "end_lifes_pkey"
  75. DETAIL: Key (id)=(1) already exists.
  76. CONTEXT: COPY end_lifes, line 1
  77. ERROR: insert or update on table "invitations" violates foreign key constraint "invitations_organisation_id_fkey"
  78. DETAIL: Key (organisation_id)=(3) is not present in table "organisations".
  79. ERROR: insert or update on table "items" violates foreign key constraint "items_delivery_id_fkey"
  80. DETAIL: Key (delivery_id)=(1388) is not present in table "deliveries".
  81. ERROR: insert or update on table "loads" violates foreign key constraint "loads_driver_id_fkey"
  82. DETAIL: Key (driver_id)=(33) is not present in table "users".
  83. ERROR: duplicate key value violates unique constraint "materials_pkey"
  84. DETAIL: Key (id)=(1) already exists.
  85. CONTEXT: COPY materials, line 1
  86. ERROR: duplicate key value violates unique constraint "organisations_pkey"
  87. DETAIL: Key (id)=(1) already exists.
  88. CONTEXT: COPY organisations, line 1
  89. ERROR: insert or update on table "preferences" violates foreign key constraint "preferences_user_id_fkey"
  90. DETAIL: Key (user_id)=(2) is not present in table "users".
  91. ERROR: insert or update on table "provisional_loads" violates foreign key constraint "provisional_loads_driver_id_fkey"
  92. DETAIL: Key (driver_id)=(38) is not present in table "users".
  93. ERROR: value too long for type character varying(50)
  94. CONTEXT: COPY sites, line 130, column line_1: "Unit PD 1 Tougher Industrial Estate, Tougher Industrial Estate"
  95. ERROR: insert or update on table "treatment_contracts" violates foreign key constraint "treatment_contracts_treatment_site_id_fkey"
  96. DETAIL: Key (treatment_site_id)=(33) is not present in table "sites".
  97. ERROR: insert or update on table "treatment_price" violates foreign key constraint "treatment_price_item_id_fkey"
  98. DETAIL: Key (item_id)=(1) is not present in table "items".
  99. ERROR: insert or update on table "treatment_rules" violates foreign key constraint "treatment_rules_contract_id_fkey"
  100. DETAIL: Key (contract_id)=(2) is not present in table "treatment_contracts".
  101. ERROR: insert or update on table "trucks" violates foreign key constraint "trucks_organisation_id_fkey"
  102. DETAIL: Key (organisation_id)=(4) is not present in table "organisations".
  103. ERROR: duplicate key value violates unique constraint "users_pkey"
  104. DETAIL: Key (id)=(1) already exists.
  105. CONTEXT: COPY users, line 78
  106. ERROR: duplicate key value violates unique constraint "waste_families_pkey"
  107. DETAIL: Key (id)=(1) already exists.
  108. CONTEXT: COPY waste_families, line 1
  109. ERROR: duplicate key value violates unique constraint "waste_regions_pkey"
  110. DETAIL: Key (id)=(1) already exists.
  111. CONTEXT: COPY waste_regions, line 1
  112. ERROR: duplicate key value violates unique constraint "wi_regions_pkey"
  113. DETAIL: Key (id)=(1) already exists.
  114. CONTEXT: COPY wi_regions, line 1
  115. ERROR: relation "categories_code_key" already exists
  116. ERROR: relation "categories_name_key" already exists
  117. ERROR: multiple primary keys for table "categories" are not allowed
  118. ERROR: relation "categories_public_id_key" already exists
  119. ERROR: multiple primary keys for table "collection_algorithms" are not allowed
  120. ERROR: relation "collection_algorithms_public_id_key" already exists
  121. ERROR: multiple primary keys for table "collection_amounts" are not allowed
  122. ERROR: relation "collection_amounts_public_id_key" already exists
  123. ERROR: multiple primary keys for table "collection_contracts" are not allowed
  124. ERROR: relation "collection_contracts_public_id_key" already exists
  125. ERROR: multiple primary keys for table "collection_items" are not allowed
  126. ERROR: relation "collection_items_public_id_key" already exists
  127. ERROR: multiple primary keys for table "collection_price" are not allowed
  128. ERROR: relation "collection_price_public_id_key" already exists
  129. ERROR: multiple primary keys for table "collection_rules" are not allowed
  130. ERROR: relation "collection_rules_public_id_key" already exists
  131. ERROR: multiple primary keys for table "collections" are not allowed
  132. ERROR: relation "collections_public_id_key" already exists
  133. ERROR: relation "container_types_name_key" already exists
  134. ERROR: multiple primary keys for table "container_types" are not allowed
  135. ERROR: relation "container_types_public_id_key" already exists
  136. ERROR: relation "counties_name_key" already exists
  137. ERROR: multiple primary keys for table "counties" are not allowed
  138. ERROR: relation "counties_public_id_key" already exists
  139. ERROR: multiple primary keys for table "cp_categories" are not allowed
  140. ERROR: relation "cp_categories_public_id_key" already exists
  141. ERROR: multiple primary keys for table "cp_category_edges" are not allowed
  142. ERROR: multiple primary keys for table "cp_contracts" are not allowed
  143. ERROR: relation "cp_contracts_public_id_key" already exists
  144. ERROR: multiple primary keys for table "cp_price" are not allowed
  145. ERROR: relation "cp_price_public_id_key" already exists
  146. ERROR: multiple primary keys for table "cp_rules" are not allowed
  147. ERROR: relation "cp_rules_public_id_key" already exists
  148. ERROR: multiple primary keys for table "deliveries" are not allowed
  149. ERROR: relation "deliveries_public_id_key" already exists
  150. ERROR: relation "end_lifes_name_key" already exists
  151. ERROR: multiple primary keys for table "end_lifes" are not allowed
  152. ERROR: relation "end_lifes_public_id_key" already exists
  153. ERROR: multiple primary keys for table "invitations" are not allowed
  154. ERROR: relation "invitations_public_id_key" already exists
  155. ERROR: multiple primary keys for table "items" are not allowed
  156. ERROR: relation "items_public_id_key" already exists
  157. ERROR: multiple primary keys for table "loads" are not allowed
  158. ERROR: relation "loads_public_id_key" already exists
  159. ERROR: relation "materials_name_key" already exists
  160. ERROR: multiple primary keys for table "materials" are not allowed
  161. ERROR: relation "materials_public_id_key" already exists
  162. ERROR: relation "organisations_name_key" already exists
  163. ERROR: multiple primary keys for table "organisations" are not allowed
  164. ERROR: relation "organisations_public_id_key" already exists
  165. ERROR: multiple primary keys for table "preferences" are not allowed
  166. ERROR: relation "preferences_public_id_key" already exists
  167. ERROR: relation "provisional_loads_external_id_key" already exists
  168. ERROR: multiple primary keys for table "provisional_loads" are not allowed
  169. ERROR: relation "provisional_loads_public_id_key" already exists
  170. ERROR: multiple primary keys for table "sites" are not allowed
  171. ERROR: relation "sites_public_id_key" already exists
  172. ERROR: multiple primary keys for table "treatment_algorithms" are not allowed
  173. ERROR: relation "treatment_algorithms_public_id_key" already exists
  174. ERROR: multiple primary keys for table "treatment_amounts" are not allowed
  175. ERROR: relation "treatment_amounts_public_id_key" already exists
  176. ERROR: multiple primary keys for table "treatment_contracts" are not allowed
  177. ERROR: relation "treatment_contracts_public_id_key" already exists
  178. ERROR: multiple primary keys for table "treatment_items" are not allowed
  179. ERROR: relation "treatment_items_public_id_key" already exists
  180. ERROR: multiple primary keys for table "treatment_price" are not allowed
  181. ERROR: relation "treatment_price_public_id_key" already exists
  182. ERROR: multiple primary keys for table "treatment_rules" are not allowed
  183. ERROR: relation "treatment_rules_public_id_key" already exists
  184. ERROR: multiple primary keys for table "trucks" are not allowed
  185. ERROR: relation "trucks_public_id_key" already exists
  186. ERROR: relation "trucks_reg_no_key" already exists
  187. ERROR: multiple primary keys for table "users" are not allowed
  188. ERROR: relation "users_public_id_key" already exists
  189. ERROR: relation "users_username_key" already exists
  190. ERROR: relation "waste_families_name_key" already exists
  191. ERROR: multiple primary keys for table "waste_families" are not allowed
  192. ERROR: relation "waste_families_public_id_key" already exists
  193. ERROR: relation "waste_regions_name_key" already exists
  194. ERROR: multiple primary keys for table "waste_regions" are not allowed
  195. ERROR: relation "waste_regions_public_id_key" already exists
  196. ERROR: relation "wi_regions_name_key" already exists
  197. ERROR: multiple primary keys for table "wi_regions" are not allowed
  198. ERROR: relation "wi_regions_public_id_key" already exists
  199. ERROR: constraint "collection_algorithms_collector_id_fkey" for relation "collection_algorithms" already exists
  200. ERROR: constraint "collection_algorithms_waste_family_id_fkey" for relation "collection_algorithms" already exists
  201. ERROR: constraint "collection_amounts_algorithm_item_id_fkey" for relation "collection_amounts" already exists
  202. ERROR: constraint "collection_amounts_category_id_fkey" for relation "collection_amounts" already exists
  203. ERROR: constraint "collection_amounts_item_id_fkey" for relation "collection_amounts" already exists
  204. ERROR: constraint "collection_contracts_contractor_id_fkey" for relation "collection_contracts" already exists
  205. ERROR: constraint "collection_items_algorithm_id_fkey" for relation "collection_items" already exists
  206. ERROR: constraint "collection_items_category_id_fkey" for relation "collection_items" already exists
  207. ERROR: constraint "collection_price_contract_id_fkey" for relation "collection_price" already exists
  208. ERROR: constraint "collection_price_item_id_fkey" for relation "collection_price" already exists
  209. ERROR: constraint "collection_price_rule_id_fkey" for relation "collection_price" already exists
  210. ERROR: constraint "collection_rules_contract_id_fkey" for relation "collection_rules" already exists
  211. ERROR: constraint "collections_load_id_fkey" for relation "collections" already exists
  212. ERROR: constraint "collections_site_id_fkey" for relation "collections" already exists
  213. ERROR: constraint "container_types_organisation_id_fkey" for relation "container_types" already exists
  214. ERROR: constraint "counties_waste_region_id_fkey" for relation "counties" already exists
  215. ERROR: constraint "cp_categories_parent_id_fkey" for relation "cp_categories" already exists
  216. ERROR: constraint "cp_category_edges_child_id_fkey" for relation "cp_category_edges" already exists
  217. ERROR: constraint "cp_category_edges_parent_id_fkey" for relation "cp_category_edges" already exists
  218. ERROR: constraint "cp_price_contract_id_fkey" for relation "cp_price" already exists
  219. ERROR: constraint "cp_price_item_id_fkey" for relation "cp_price" already exists
  220. ERROR: constraint "cp_price_rule_id_fkey" for relation "cp_price" already exists
  221. ERROR: constraint "cp_rules_contract_id_fkey" for relation "cp_rules" already exists
  222. ERROR: constraint "deliveries_load_id_fkey" for relation "deliveries" already exists
  223. ERROR: constraint "deliveries_site_id_fkey" for relation "deliveries" already exists
  224. ERROR: constraint "invitations_author_id_fkey" for relation "invitations" already exists
  225. ERROR: constraint "invitations_organisation_id_fkey" for relation "invitations" already exists
  226. ERROR: constraint "invitations_user_id_fkey" for relation "invitations" already exists
  227. ERROR: constraint "items_collection_id_fkey" for relation "items" already exists
  228. ERROR: constraint "items_container_type_id_fkey" for relation "items" already exists
  229. ERROR: constraint "items_delivery_id_fkey" for relation "items" already exists
  230. ERROR: constraint "items_waste_family_id_fkey" for relation "items" already exists
  231. ERROR: constraint "loads_driver_id_fkey" for relation "loads" already exists
  232. ERROR: constraint "loads_truck_id_fkey" for relation "loads" already exists
  233. ERROR: constraint "materials_end_life_id_fkey" for relation "materials" already exists
  234. ERROR: constraint "preferences_user_id_fkey" for relation "preferences" already exists
  235. ERROR: constraint "provisional_loads_driver_id_fkey" for relation "provisional_loads" already exists
  236. ERROR: constraint "provisional_loads_load_id_fkey" for relation "provisional_loads" already exists
  237. ERROR: constraint "provisional_loads_truck_id_fkey" for relation "provisional_loads" already exists
  238. ERROR: constraint "sites_county_id_fkey" for relation "sites" already exists
  239. ERROR: constraint "sites_cp_category_id_fkey" for relation "sites" already exists
  240. ERROR: constraint "sites_local_authority_id_fkey" for relation "sites" already exists
  241. ERROR: constraint "sites_organisation_id_fkey" for relation "sites" already exists
  242. ERROR: constraint "sites_waste_region_id_fkey" for relation "sites" already exists
  243. ERROR: constraint "sites_wi_region_id_fkey" for relation "sites" already exists
  244. ERROR: constraint "treatment_algorithms_treatment_site_id_fkey" for relation "treatment_algorithms" already exists
  245. ERROR: constraint "treatment_algorithms_waste_family_id_fkey" for relation "treatment_algorithms" already exists
  246. ERROR: constraint "treatment_amounts_algorithm_item_id_fkey" for relation "treatment_amounts" already exists
  247. ERROR: constraint "treatment_amounts_end_life_id_fkey" for relation "treatment_amounts" already exists
  248. ERROR: constraint "treatment_amounts_item_id_fkey" for relation "treatment_amounts" already exists
  249. ERROR: constraint "treatment_amounts_material_id_fkey" for relation "treatment_amounts" already exists
  250. ERROR: constraint "treatment_contracts_treatment_site_id_fkey" for relation "treatment_contracts" already exists
  251. ERROR: constraint "treatment_items_algorithm_id_fkey" for relation "treatment_items" already exists
  252. ERROR: constraint "treatment_items_end_life_id_fkey" for relation "treatment_items" already exists
  253. ERROR: constraint "treatment_items_material_id_fkey" for relation "treatment_items" already exists
  254. ERROR: constraint "treatment_price_contract_id_fkey" for relation "treatment_price" already exists
  255. ERROR: constraint "treatment_price_item_id_fkey" for relation "treatment_price" already exists
  256. ERROR: constraint "treatment_price_rule_id_fkey" for relation "treatment_price" already exists
  257. ERROR: constraint "treatment_rules_contract_id_fkey" for relation "treatment_rules" already exists
  258. ERROR: constraint "treatment_rules_waste_family_id_fkey" for relation "treatment_rules" already exists
  259. ERROR: constraint "trucks_organisation_id_fkey" for relation "trucks" already exists
  260. ERROR: constraint "users_organisation_id_fkey" for relation "users" already exists
  261. REVOKE
  262. REVOKE
  263. GRANT
  264. GRANT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!