Revision 4080
Added by daigle about 16 years ago
| upgrade-db-to-1.6-postgres.sql | ||
|---|---|---|
| 120 | 120 |
* Delete the records from xml_index table which point to old revisions in xml_index |
| 121 | 121 |
* This is possible for documents for which the indexing thread failed during UPDATE |
| 122 | 122 |
*/ |
| 123 |
DELETE FROM xml_index WHERE nodeid = xml_nodes_revisions.nodeid;
|
|
| 123 |
DELETE FROM xml_index WHERE nodeid IN (SELECT nodeid FROM xml_nodes_revisions);
|
|
| 124 | 124 |
|
| 125 | 125 |
|
| 126 | 126 |
|
Also available in: Unified diff
Merge 1.9 changes into Head