PostgreSQL does not support the update subselect syntax used to update term_node.

Additional system_update_6043 changes the primary key on term_node to (tid, vid) but that happens before system_update_6044 which removed rows with vid = 0. Removing those rows first is necessary (at least for my database) to avoid duplicate (tid,vid) tuples with the new key.

The attached patch corrects both of these issues.

CommentFileSizeAuthor
system.install.6001-6043.patch1.01 KBrbroberts

Comments

rbroberts’s picture

rbroberts commented
Component: update system » system.module
Status: Active » Needs review

Correcting status, and component.

Status: Needs review » Needs work
Issue tags: -upgrade, -drupal 6.19, -Drupal 5.23

The last submitted patch, system.install.6001-6043.patch, failed testing.

Issue tags: +upgrade, +drupal 6.19, +Drupal 5.23

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.

Status: Needs work » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.