Revision 8604
Added by ben leinfelder over 10 years ago
upgrade-db-to-2.4.0-postgres.sql | ||
---|---|---|
64 | 64 |
AND id.guid = cd.guid; |
65 | 65 |
|
66 | 66 |
-- look at them |
67 |
/* |
|
67 | 68 |
SELECT * |
68 | 69 |
FROM restore_documents; |
70 |
*/ |
|
69 | 71 |
|
70 | 72 |
--STOP HERE WHEN TESTING |
71 | 73 |
|
... | ... | |
112 | 114 |
* (Avoids encountering this issue again) |
113 | 115 |
*/ |
114 | 116 |
|
115 |
/* Check the numbers |
|
117 |
/* Check the numbers in xml_revisions
|
|
116 | 118 |
*/ |
119 |
/* |
|
117 | 120 |
SELECT count(id.guid) |
118 | 121 |
FROM xml_revisions x, |
119 | 122 |
identifier id, |
... | ... | |
123 | 126 |
AND id.guid = sm.guid |
124 | 127 |
AND sm.obsoleted_by IS NOT null |
125 | 128 |
AND sm.archived = 'true'; |
129 |
*/ |
|
126 | 130 |
|
127 | 131 |
/*Do the update on xml_revisions |
128 | 132 |
*/ |
... | ... | |
139 | 143 |
/** |
140 | 144 |
* Check numbers in xml_documents |
141 | 145 |
*/ |
146 |
/* |
|
142 | 147 |
SELECT count(id.guid) |
143 | 148 |
FROM xml_documents x, |
144 | 149 |
identifier id, |
... | ... | |
148 | 153 |
AND id.guid = sm.guid |
149 | 154 |
AND sm.obsoleted_by IS NOT null |
150 | 155 |
AND sm.archived = 'true'; |
156 |
*/ |
|
151 | 157 |
|
152 | 158 |
/*Do the update on xml_documents |
153 | 159 |
*/ |
Also available in: Unified diff
comment out the select statements so they do not run during real upgrade.