Timeline for How do I validate all my constraints in postgresql?
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 9 at 15:39 | answer | added | Gman | timeline score: 0 | |
| Oct 4, 2019 at 8:21 | answer | added | Maneki | timeline score: 6 | |
| Jun 16, 2018 at 6:11 | history | edited | Jack Douglas |
edited tags
|
|
| Jun 15, 2018 at 6:43 | vote | accept | Niels Kristian | ||
| Jun 14, 2018 at 16:53 | answer | added | Evan Carroll | timeline score: 5 | |
| Apr 9, 2014 at 12:23 | comment | added | ypercubeᵀᴹ | This script by depesz seems relative: github.com/omniti-labs/pgtreats/blob/master/tools/… | |
| S Apr 9, 2014 at 7:13 | history | suggested | shgnInc |
Just adding some tags.
|
|
| Apr 9, 2014 at 5:30 | review | Suggested edits | |||
| S Apr 9, 2014 at 7:13 | |||||
| Apr 9, 2014 at 3:27 | answer | added | druzin | timeline score: 7 | |
| Apr 8, 2014 at 15:41 | history | edited | Niels Kristian | CC BY-SA 3.0 |
added 226 characters in body
|
| Apr 8, 2014 at 13:28 | history | edited | Niels Kristian | CC BY-SA 3.0 |
added 453 characters in body
|
| Apr 8, 2014 at 11:34 | comment | added | Craig Ringer | Dropping and re-creating constraints is certainly one way to do it - probably quite good enough for the job, too :-) | |
| Apr 8, 2014 at 11:30 | comment | added | Niels Kristian | I found this, that I'm hacking around with currently... blog.hagander.net/archives/… | |
| Apr 8, 2014 at 11:20 | comment | added | Craig Ringer |
I wrote a script for this, but I'm not able to publish it at this time. I'll check and see if I can get it opened. You should be able to bang a script together to do it by looping over the contents of pg_constraint, but there's some hoop jumping required to deal with multi-column constraints etc.
|
|
| Apr 8, 2014 at 11:05 | history | tweeted | twitter.com/#!/StackDBAs/status/453488825499934721 | ||
| Apr 8, 2014 at 8:01 | history | asked | Niels Kristian | CC BY-SA 3.0 |