API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 18th, 2018
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 13.71 KB | None | 0 0
raw download clone embed print report
  1. edgar@x230 ~/t/d/h/team-18 (master)> docker run -it --rm --link some-postgres:postgres -v (pwd):/workspace postgres psql -x -h postgres -U postgres -f workspace/data.sql
  2. INSERT 0 1
  3. INSERT 0 1
  4. INSERT 0 1
  5. INSERT 0 1
  6. INSERT 0 1
  7. INSERT 0 1
  8. INSERT 0 1
  9. psql:workspace/data.sql:9: ERROR:  null value in column "manager_id" violates not-null constraint
  10. DETAIL:  Failing row contains (1, Russia, null).
  11. psql:workspace/data.sql:10: ERROR:  null value in column "manager_id" violates not-null constraint
  12. DETAIL:  Failing row contains (2, Germany, null).
  13. psql:workspace/data.sql:11: ERROR:  null value in column "manager_id" violates not-null constraint
  14. DETAIL:  Failing row contains (3, France, null).
  15. psql:workspace/data.sql:12: ERROR:  null value in column "manager_id" violates not-null constraint
  16. DETAIL:  Failing row contains (4, China, null).
  17. psql:workspace/data.sql:13: ERROR:  null value in column "manager_id" violates not-null constraint
  18. DETAIL:  Failing row contains (5, Japan, null).
  19. psql:workspace/data.sql:14: ERROR:  null value in column "manager_id" violates not-null constraint
  20. DETAIL:  Failing row contains (6, Israel, null).
  21. psql:workspace/data.sql:15: ERROR:  null value in column "manager_id" violates not-null constraint
  22. DETAIL:  Failing row contains (7, Spain, null).
  23. psql:workspace/data.sql:16: ERROR:  null value in column "manager_id" violates not-null constraint
  24. DETAIL:  Failing row contains (8, Italy, null).
  25. INSERT 0 1
  26. INSERT 0 1
  27. INSERT 0 1
  28. INSERT 0 1
  29. INSERT 0 1
  30. psql:workspace/data.sql:24: ERROR:  column "functionality_id" of relation "building" does not exist
  31. LINE 1: INSERT INTO Building (functionality_id, street, house, name)...
  32.                               ^
  33. psql:workspace/data.sql:25: ERROR:  column "functionality_id" of relation "building" does not exist
  34. LINE 1: INSERT INTO Building (functionality_id, street, house, name)...
  35.                               ^
  36. psql:workspace/data.sql:26: ERROR:  column "functionality_id" of relation "building" does not exist
  37. LINE 1: INSERT INTO Building (functionality_id, street, house, name)...
  38.                               ^
  39. psql:workspace/data.sql:27: ERROR:  column "functionality_id" of relation "building" does not exist
  40. LINE 1: INSERT INTO Building (functionality_id, street, house, name)...
  41.                               ^
  42. INSERT 0 1
  43. INSERT 0 1
  44. INSERT 0 1
  45. psql:workspace/data.sql:33: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  46. DETAIL:  Key (country_id)=(1) is not present in table "countrydelegation".
  47. psql:workspace/data.sql:34: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  48. DETAIL:  Key (country_id)=(3) is not present in table "countrydelegation".
  49. psql:workspace/data.sql:35: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  50. DETAIL:  Key (country_id)=(1) is not present in table "countrydelegation".
  51. psql:workspace/data.sql:36: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  52. DETAIL:  Key (country_id)=(5) is not present in table "countrydelegation".
  53. psql:workspace/data.sql:37: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  54. DETAIL:  Key (country_id)=(5) is not present in table "countrydelegation".
  55. psql:workspace/data.sql:38: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  56. DETAIL:  Key (country_id)=(6) is not present in table "countrydelegation".
  57. psql:workspace/data.sql:39: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  58. DETAIL:  Key (country_id)=(8) is not present in table "countrydelegation".
  59. psql:workspace/data.sql:40: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  60. DETAIL:  Key (country_id)=(2) is not present in table "countrydelegation".
  61. psql:workspace/data.sql:41: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  62. DETAIL:  Key (country_id)=(5) is not present in table "countrydelegation".
  63. psql:workspace/data.sql:42: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  64. DETAIL:  Key (country_id)=(3) is not present in table "countrydelegation".
  65. psql:workspace/data.sql:43: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  66. DETAIL:  Key (country_id)=(8) is not present in table "countrydelegation".
  67. psql:workspace/data.sql:44: ERROR:  insert or update on table "sportsman" violates foreign key constraint "sportsman_country_id_fkey"
  68. DETAIL:  Key (country_id)=(8) is not present in table "countrydelegation".
  69. psql:workspace/data.sql:46: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  70. DETAIL:  Key (sportsman_id)=(1) is not present in table "sportsman".
  71. psql:workspace/data.sql:47: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  72. DETAIL:  Key (sportsman_id)=(1) is not present in table "sportsman".
  73. psql:workspace/data.sql:48: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  74. DETAIL:  Key (sportsman_id)=(2) is not present in table "sportsman".
  75. psql:workspace/data.sql:49: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  76. DETAIL:  Key (sportsman_id)=(1) is not present in table "sportsman".
  77. psql:workspace/data.sql:50: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  78. DETAIL:  Key (sportsman_id)=(2) is not present in table "sportsman".
  79. psql:workspace/data.sql:51: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  80. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  81. psql:workspace/data.sql:52: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  82. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  83. psql:workspace/data.sql:53: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  84. DETAIL:  Key (sportsman_id)=(4) is not present in table "sportsman".
  85. psql:workspace/data.sql:54: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  86. DETAIL:  Key (sportsman_id)=(4) is not present in table "sportsman".
  87. psql:workspace/data.sql:55: ERROR:  insert or update on table "sportsmantosport" violates foreign key constraint "sportsmantosport_sportsman_id_fkey"
  88. DETAIL:  Key (sportsman_id)=(4) is not present in table "sportsman".
  89. psql:workspace/data.sql:57: ERROR:  null value in column "id" violates not-null constraint
  90. DETAIL:  Failing row contains (null, 1, Andrey, +79818414604, 1).
  91. psql:workspace/data.sql:58: ERROR:  null value in column "id" violates not-null constraint
  92. DETAIL:  Failing row contains (null, 2, Gennadzi, +79818414605, 3).
  93. psql:workspace/data.sql:59: ERROR:  null value in column "id" violates not-null constraint
  94. DETAIL:  Failing row contains (null, 3, Nikolay, +79818414606, 3).
  95. psql:workspace/data.sql:60: ERROR:  null value in column "id" violates not-null constraint
  96. DETAIL:  Failing row contains (null, 4, Ivan, +79818414607, 1).
  97. psql:workspace/data.sql:61: ERROR:  null value in column "id" violates not-null constraint
  98. DETAIL:  Failing row contains (null, 5, Masha, +79818414607, 3).
  99. psql:workspace/data.sql:62: ERROR:  null value in column "id" violates not-null constraint
  100. DETAIL:  Failing row contains (null, 6, Bob, +49268464613, 2).
  101. psql:workspace/data.sql:63: ERROR:  null value in column "id" violates not-null constraint
  102. DETAIL:  Failing row contains (null, 7, John, +62278824605, 4).
  103. psql:workspace/data.sql:64: ERROR:  null value in column "id" violates not-null constraint
  104. DETAIL:  Failing row contains (null, 8, George, +7769964311, 2).
  105. psql:workspace/data.sql:66: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  106. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  107.                                            ^
  108. psql:workspace/data.sql:67: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  109. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  110.                                            ^
  111. psql:workspace/data.sql:68: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  112. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  113.                                            ^
  114. psql:workspace/data.sql:69: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  115. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  116.                                            ^
  117. psql:workspace/data.sql:70: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  118. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  119.                                            ^
  120. psql:workspace/data.sql:71: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  121. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  122.                                            ^
  123. psql:workspace/data.sql:72: ERROR:  column "competition_timestamp" of relation "competition" does not exist
  124. LINE 1: INSERT INTO Competition (sport_id, competition_timestamp, bu...
  125.                                            ^
  126. psql:workspace/data.sql:74: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  127. DETAIL:  Key (sportsman_id)=(1) is not present in table "sportsman".
  128. psql:workspace/data.sql:75: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  129. DETAIL:  Key (sportsman_id)=(1) is not present in table "sportsman".
  130. psql:workspace/data.sql:76: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  131. DETAIL:  Key (sportsman_id)=(2) is not present in table "sportsman".
  132. psql:workspace/data.sql:77: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  133. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  134. psql:workspace/data.sql:78: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  135. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  136. psql:workspace/data.sql:79: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  137. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  138. psql:workspace/data.sql:80: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  139. DETAIL:  Key (sportsman_id)=(3) is not present in table "sportsman".
  140. psql:workspace/data.sql:81: ERROR:  insert or update on table "sportsmantocompetition" violates foreign key constraint "sportsmantocompetition_sportsman_id_fkey"
  141. DETAIL:  Key (sportsman_id)=(4) is not present in table "sportsman".
  142. psql:workspace/data.sql:83: ERROR:  column "number" of relation "vehicle" does not exist
  143. LINE 1: INSERT INTO Vehicle (number, capacity) VALUES ('T672OP', 12)...
  144.                              ^
  145. psql:workspace/data.sql:84: ERROR:  column "number" of relation "vehicle" does not exist
  146. LINE 1: INSERT INTO Vehicle (number, capacity) VALUES ('S991GO', 14)...
  147.                              ^
  148. psql:workspace/data.sql:85: ERROR:  column "number" of relation "vehicle" does not exist
  149. LINE 1: INSERT INTO Vehicle (number, capacity) VALUES ('N991WE', 7);
  150.                              ^
  151. psql:workspace/data.sql:86: ERROR:  column "number" of relation "vehicle" does not exist
  152. LINE 1: INSERT INTO Vehicle (number, capacity) VALUES ('K861VL', 5);
  153.                              ^
  154. psql:workspace/data.sql:88: ERROR:  column "task_timestamp" of relation "task" does not exist
  155. LINE 1: INSERT INTO Task (content, vehicle_id, task_timestamp) VALUE...
  156.                                                ^
  157. psql:workspace/data.sql:89: ERROR:  column "task_timestamp" of relation "task" does not exist
  158. LINE 1: INSERT INTO Task (content, vehicle_id, task_timestamp) VALUE...
  159.                                                ^
  160. psql:workspace/data.sql:90: ERROR:  column "task_timestamp" of relation "task" does not exist
  161. LINE 1: INSERT INTO Task (content, vehicle_id, task_timestamp) VALUE...
  162.                                                ^
  163. psql:workspace/data.sql:91: ERROR:  column "task_timestamp" of relation "task" does not exist
  164. LINE 1: INSERT INTO Task (content, vehicle_id, task_timestamp) VALUE...
  165.                                                ^
  166. psql:workspace/data.sql:94: ERROR:  relation "coun" does not exist
  167. LINE 1: INSERT INTO Coun (key, val) VALUES (1, 5);
  168.                     ^
  169. psql:workspace/data.sql:95: ERROR:  relation "coun" does not exist
  170. LINE 1: INSERT INTO Coun (key, val) VALUES (1, 6);
  171.                     ^
  172. psql:workspace/data.sql:96: ERROR:  relation "coun" does not exist
  173. LINE 1: INSERT INTO Coun (key, val) VALUES (1, 7);
  174.                     ^
  175. psql:workspace/data.sql:97: ERROR:  relation "coun" does not exist
  176. LINE 1: INSERT INTO Coun (key, val) VALUES (2, 4);
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!