Timeline for ERROR: check constraint is violated by some row
Current License: CC BY-SA 3.0
25 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 3, 2016 at 15:53 | history | edited | Erwin Brandstetter |
edited tags
|
|
| Feb 3, 2016 at 15:32 | answer | added | Erwin Brandstetter | timeline score: 1 | |
| Feb 3, 2016 at 9:13 | vote | accept | CommunityBot | ||
| Feb 3, 2016 at 9:06 | history | rollback | Paul White♦ |
Rollback to Revision 9
|
|
| Feb 3, 2016 at 9:05 | history | rollback | Paul White♦ |
Rollback to Revision 10
|
|
| Feb 3, 2016 at 7:31 | review | Close votes | |||
| Feb 3, 2016 at 16:59 | |||||
| Feb 3, 2016 at 7:20 | comment | added | ypercubeᵀᴹ | The solution is obvious, isn't it? Modify the rows that violate the constraint, then add the constraint. And your "update" still shows that you tried Verace's query and you find those 59 rows, which are irrelevant to the constraint you show. | |
| Feb 3, 2016 at 7:19 | comment | added | user83914 | @ypercubeᵀᴹ Yes... But you guys only show how to find the problem and not how to solve it.. I was able to find using select * ..... WHERE NOT NULL.. etc. But, I still have the problem and I can't add the constraint. I updated the question to get it more understandable | |
| Feb 3, 2016 at 7:17 | comment | added | ypercubeᵀᴹ | And did you try the queries we posted? Verace's answer gave different advice than mine and Lennart's (which are the same). | |
| Feb 3, 2016 at 1:32 | history | edited | user83914 | CC BY-SA 3.0 |
deleted 514 characters in body
|
| Jan 31, 2016 at 12:59 | history | tweeted | twitter.com/StackDBAs/status/693780747669368832 | ||
| Jan 28, 2016 at 23:56 | vote | accept | CommunityBot | ||
| Feb 1, 2016 at 20:08 | |||||
| Jan 26, 2016 at 5:01 | answer | added | Lennart - Slava Ukraini | timeline score: 6 | |
| Jan 26, 2016 at 4:37 | history | edited | Paul White♦ |
edited tags
|
|
| Jan 25, 2016 at 6:53 | answer | added | ypercubeᵀᴹ | timeline score: 3 | |
| Jan 25, 2016 at 6:51 | answer | added | Vérace | timeline score: 5 | |
| Jan 25, 2016 at 6:41 | history | edited | Paul White♦ |
Rollback to Revision 7 - a new question has been asked for the rolled back edit
|
|
| Jan 25, 2016 at 5:36 | history | edited | user83914 | CC BY-SA 3.0 |
added 351 characters in body
|
| Jan 25, 2016 at 1:09 | history | edited | user83914 | CC BY-SA 3.0 |
added 415 characters in body
|
| Jan 25, 2016 at 1:02 | history | edited | user83914 | CC BY-SA 3.0 |
added 194 characters in body
|
| Jan 25, 2016 at 0:53 | history | edited | user83914 | CC BY-SA 3.0 |
deleted 193 characters in body
|
| Jan 25, 2016 at 0:44 | history | edited | user83914 | CC BY-SA 3.0 |
added 227 characters in body
|
| Jan 24, 2016 at 23:45 | history | edited | user83914 | CC BY-SA 3.0 |
added 434 characters in body
|
| Jan 24, 2016 at 23:04 | history | edited | user83914 | CC BY-SA 3.0 |
added 364 characters in body
|
| Jan 24, 2016 at 22:58 | history | asked | user83914 | CC BY-SA 3.0 |